Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access+vba+courses+london - criteria query

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+vba+courses+london - Criteria Query

access+vba+courses+london - Criteria Query

ResolvedVersion Standard

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

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.14 secs.