access+vba+courses+london - criteria query

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

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

access+vba+courses+london - Criteria Query

resolvedResolved · Low Priority · Version 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:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Server loaded in 0.09 secs.