using "like" in a parameter

A

aadele03

I want to send birthday cards to my workers, how can i set a parameter
in a query where i can just type the month and the birthdates, that
fall into that month appear in the results.
The bithdate has this format
12/1/1949
8/25/1984
 
J

Jeff Boyce

Perhaps you don't need to use "like" ... take a look at the Month() function
in Access HELP. It sounds like you want to find all birthdates where
Month([YourDate]) = (some month number you enter -- e.g., 3 for March)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
L

Lynn Trapp

SELECTLName,FName,Birthdate
FROM YourTable
WHERE (((Format(Birthdate,"mm"))=[enter month]));
 
Top