Generate a list of birthday names for a given month (1 Viewer)

[dbs_help]

I am using Access 2007 and run a newsletter for a local Elks club. Each monthly issue must contain a list of people's names who have their birthday on that given month. I am trying to generate a query to make this happen but am confused while trying to use the date function.

Any help would be greatly appreciated.

 

[namliam]

date() - Day(date()) + 1

Jumps to the first day of this month

Now use the dateadd function to do the rest

 

[dbs_help]

That's great!! Thank you. Now let me be a real pain and ask you what is the dateadd function? And do I use both in the Criteria box on the query window?

 

[namliam]

Try the access help for the DateAdd function, its quite clear on how to use it...