Query to find latest date in table

[prodtest]

I need to perform a simple query which returns the last record entered in a table, from this query I will run a report.
I have built a report based on the query, is there an expression I can use in the date field of my query which will return just the last entry ?

 

[PHV]

If the records are timestamped you may try something like this:
SELECT * FROM yourTable
WHERE yourDateTimeField = (SELECT Max(yourDateTimeField) FROM yourTable)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244