Date query

[ExcelDummie]

New to access, doing a query to find out who has done first aid
qualifications. Have done this but need to show people who have valid
qualifications so the expiry date of the qualification is greater than todays
date
tried >=Date() but no joy should this work?

 

[Jerry Whittle]

Yes it should IF:
1. You have it as the criteria for a Date/Time field and not a text or
number field that happens to look like a date. Very common mistake.

2. You don't have a references problem where the Date() function is broken.
It's a very common, and easily fixable, problem. Try using >=Now() instead
as it often works when Date() doesn't. Now() is currnet date AND time. If Now
works, do a Google search about fixing broken Access references

3. Your dates are actually the year 2006 and not 1906. If your dates are
formatted and displayed with 2 digit years, you really don't know what
century.

Maybe if you describe the exact reason for the lack of joy, we can bring
bliss to your database. ;-)