last record for each date

[Guest]

Hello,
i need to get the last record for each day in a table, there are a few
records for certain dates. Thanks for the Help.
Jennifer

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "MaxQueryProblem.mdb" which illustrates a couple of ways to do
this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L