baldeagle
Registered User.
- Local time
- Today, 09:33
- Joined
- Nov 9, 2004
- Messages
- 38
The "last" total in an Access query is unpredictiable. I have a Journal, with the main form/dataset being linked to the entries of that day. I would expect the 'last' total word to give me the last entry of that day, ie. what I ate for supper. But in the two qrys shown, it does the opposite. What is the most relable way to get the last entry of that day (ie. the one with the highest journalID)?
Sample Database attached.

Sample Database attached.