Anne has attended:
Access Introduction course
Criteria Query
I want to create a query when I only get details of people who are older than a certain date. I have set up date of birth in tables with an input mask of short date, but when I query it with <00/00/00 I get a modified query <the day rather than the year. How can I alter this?
RE: Criteria Query
Hello Anne
When querying dates, use
>#00/00/00#
Hashes are important in this case.
regards
Richard