most recent record

[Guest]

I need to run a file against a larger db to get the current status. How to I
write the query to pull only the most recent entry based on the record time
stamp field in the larger db. Some items may have several entries and some
only one.

Thanks in advance

 

[Tom Ellison]

Dear Cindy:

Would you please start by providing a query that reports what you want, but
without eliminating those rows that are not the "most recent" ones, but
which include the date/time column from which you want to select only the
most recent?

Will this query return only one row, the most recent? Or will it return the
most recent for each value, or combination of values, in one or more other
columns, what I would call a "group." If this is the case, specify what
column(s) make up the group so I can code for that.

On this basis, I can probably add what you need for what you have requested.

Tom Ellison
Microsoft Access MVP