Date of Local Machine

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

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())

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Babadog" wrote in message
...
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