S
SpookiePower
I have a Table called TReport which have a field called
daReportDate, that holds the date where the record was created.
I also have a field, id, that is a autonumber field.
I now want to get the date for the latest post. I have done
it this way -
SELECT DateValue(daReportDate)
FROM TReport
WHERE id = (select Max(id) from TReport)
- it seems to work, but is it the right way to do it ?
daReportDate, that holds the date where the record was created.
I also have a field, id, that is a autonumber field.
I now want to get the date for the latest post. I have done
it this way -
SELECT DateValue(daReportDate)
FROM TReport
WHERE id = (select Max(id) from TReport)
- it seems to work, but is it the right way to do it ?
