Date of Local Machine

B

Babadog

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
 
A

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