Help with criteria in a query

  • Thread starter Thread starter Ken
  • Start date Start date
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
 
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,
 
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.
 
Back
Top