Birthday Lists in MS Access

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I am using short date format (MM/DD/YYYY) in MS Access
and am trying to make a query that will list all clients
with birthdays in a certain month. (i.e. only Jan, etc.)
but all I get is a complete listing of all birthdays.
Not sure what I am missing...please help....
here is what I have so far....

SELECT Main.[Last Name], Main.[First Name], Main.BDay
FROM Main
WHERE Main.BDay
ORDER BY Main.BDay;

Not sure what to put in for WHERE...
planning on making 12 queries, 1 for Each
month....selected via command buttons...

pls email any solutions to (e-mail address removed)
To whom ever responds....Thank you for your help!!
 
SELECT Main.[Last Name], Main.[First Name], Main.BDay
FROM Main
WHERE Month(BDay) = [Enter Month Number]
ORDER BY Main.BDay;
 
Back
Top