I have a table that I need to have a query to get the last record for each day.
For sake of this example, I will keep it simple.
Let us call the table [dta]
Let us assume the fields are.
Now then I know how to use Dmax("ID","dta","Date") To get the last record. However I need that Last record for each and every day...????????