Advanced Filter

D

Dee

How would I filter dates in a datasheet that I only want the criteria to be
the year. For examples the field I want to search is a Date of Birth. The
date format has the day, month and year. How would I specify if I want to
filter all subjects born before 1955 for example.

Thanks in advance for your help.

Best regards,

Dolores
 
A

AMO

In the query add a new column that is something like "BirthYear:Year([DOB])"
-- this exaple is for the data field with the Date of Birth named DOB,
BirthYear is the name of the new field. Then put your criteria on this field
(ie < 1955)

Home this helps,
AMO
 
V

Van T. Dinh

Do you meant the DatasheetView of the Table?

* Open the Advanced Filter grid.

* In the Field row of the first empty Column, create aCalculated Field:

TheYear: Year([DOB])

DOB is the Field name.

In the criteria row of the same Column, type:

< 1955

* Apply the Filter

Personally, I just right-click on the DOB Field of any row and type in the
Filter row of the shortcut Menu:

< #01/01/1955#
 
Top