most current date

[Guest]

Hi,
My old query that used to look for anything >#12/31/03# used to be
sufficient and each year i would change the year because there would be only
one record per year. Now that is changing and i was wondering if there are
any functions---how i could query for the most recent record. thanks.

 

[Duane Hookom]

Try to think if you have provided enough information for us to provide more
than a generic guess at a solution. Pretend you can't see your table,
fields, or data and know very little about your requirements.

Then, try to come back with the information that makes providing a solution
more realistic.

 

[John Spencer (MVP)]

Guessing without sufficient details.

Look up DMAX in the online help (VBA function)

Try using a query using the Max Function against your date field.