Birthday Date by month

[idcowboy]

I am tiring to pull a birthday report for the month I specify. The name of the field where I have the birth date is “birthday” I have tried everything I can think of. Help!!! Thanks in advance

 

[lespaul]

Do you have a query that is the source of the report? It should be something like:

SELECT * FROM SomeTable WHERE Month(Birthday) = [Enter month (1 - 12)]

I'm pretty sure the month function returns the # of the month, may have to check the help on that.

Leslie

 

[idcowboy]

Call me stupid but how would I put that into a querie?

 

[lespaul]

I would never call anyone stupid:

switch to the SQL view from the design grid (in the top left of the tool bar is a drop down menu for the view, SQL, Design Grid, or Datasheet view), paste the SQL and change the tablename.

 

[idcowboy]

Thanks it works great!