Date of Local Machine

[Guest]

hello

My DataBase have one field i use Date/Hour the name is NASCIMENTO
In my querie i need return alls birthday using the Date of my local machine.
For example: today is 4/4/2007 i need return al birthdays of april
thnak's for atention

 

[Allen Browne]

1. Create a query that uses this table.

2. Type this into a fresh column in the Field row:
Month([NASCIMENTO])

3. In the Criteria row under this field, enter:
Month(Date())