109bow
Registered User.
- Local time
- Today, 10:45
- Joined
- Oct 24, 2007
- Messages
- 141
Hi all, I have a query that I need to filter results from 2 fields. I have one field that filters data of 1,2,3 or 4 to return a 1. but I need to filter that further to return the last entry by date. I have used DMax("[date]","09ts data") in the date field, but the query returns empty fields.
Is there a way of doing this in one query or do I need two separate queries.
I have no experience of VB, so I don't know how to do it that way.
Thanks
Is there a way of doing this in one query or do I need two separate queries.
I have no experience of VB, so I don't know how to do it that way.
Thanks