How do I set the criteria in a query so that I can
retrieve the people whose birthday is in november?
I already have these fiels
firstname, lastname, birthday,spousename,
spousebirthday,kidname, kid birthday
please help.
tell me how to write it word for word. I am not a tech
guru
thanks
Open your database.
On the Queries tab select the button for a New Query.
Choose your table name.
Select whichever fields you want to see - just doubleclick the
fieldnames and they will appear in the query grid.
In a vacant Field cell in the top row of the query grid type
BirthdayMonth: Month([birthday])
On the Criteria line under this field type the number 11.
Add two more fields, Month([spousebirthday]) and Month([kid birthday])
and put 11 under each of them too, on separate lines in the criteria.
Note that a) some families have more than one child; b) this query
will retrieve the entire record, no matter whose birthday it is; and
c) families sometimes have different last names for different members.
You may want to consider having a Families table related one to many
to a People table, allowing for multiple children and for each person
to have their own name and birthdate without making your table wider.
