Help with criteria in a query

K

Ken

Hi,
I have a query that shows me everyone's birthday.

What would I do so that I can see just all the birthdays
in May for example.

Thanks in advance for any help.

Ken
 
C

Cheryl Fischer

In an empty column in your query, paste the following expression in the
first row:

Month([BirthDate])

In Criteria: row for that column, type the following:

[Enter a number for the desired month:]

When you save and then run your query, you can enter the desired month
number (5 for May, 8 for August, etc.) and the query will return all birth
dates for that month.

hth,
 
G

Guest

Hi,
In your query create an expression (new field)
Month: DatePart("m",[field])
under criteria, enter the month you want
Now you can use the month field on your form
and create a combo box that will filter the months.
 
Top