show most recent

[nonrev1]

I have a table with id numbers [id] by account. The table also has a field for the [date] and [time] that represents when the information was entered. I would like to build a query that will display only the most recent entries - so where [id] is duped show only the most current record based on [date] and then [time]. Can someone help me with the best approach to this? TIA

 

[bdp]

In your first query, select the Account Number field and the Date. Turn on the 'Totals' row from the View Menu. Ensure that the Totals for each of the fields says Group By. In the Date column, select Descending for the Sort.

Create another query which will use the previous query you just created as its source. Select the fields and turn the Totals on once again. In the Totals for the Date column, select Last.

This will display the most recent date for each account number. For example, if there are 3 records for account number 5 on different dates, only the last date (most recent) will be displayed.