Show latest record only

M

Mike Rotch

I am trying to get a query to show the latest record only.

It looks like the easiest way would be to set the
criteria to show the highest number of my ID# field
only. But how do I do this?

Thanks,
Mike
 
T

Tony Vrolyk

Setup your query as normal, sorting on your ID field in Descending order.
While still in design view, click View | Properties (or press F4; or right
click in table window and select Properties). In the Top Values field set it
to 1. There is a drop down with some available values but you can enter any
whole number or percentage.

I assume you ID field is an Autonumber (Increment) field. If not this may
not prove to be a reliable method. If so it will show the last created
record. If you have a field that is a date stamp you can use that to show
the last edited record.

Tony
 
Top