Birthdays NEXT month

[Guest]

Hi team!

I currently have a query returning birthdays *this* month by using
[Birthdate]=Month(Now()).

How do I modify this to return the birthdays for *next* month?

Many thanks in advance,
Suzy

 

[Al Camp]

Suzy,
You wrote

I currently have a query returning birthdays *this* month by using
[Birthdate]=Month(Now())

In order for that to work, Birthdate would have to be a number between 1
and 12. If that's true, then...
[Birthdate] = Month(DateAdd("m",1,Now()))

If Birthdate is actually a legitimate date (mm/dd/yy) then I think you
want...
Month([Birthdate]) = Month(DateAdd("m",1,Now()))
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi team!

I currently have a query returning birthdays *this* month by using
[Birthdate]=Month(Now()).

How do I modify this to return the birthdays for *next* month?

Many thanks in advance,
Suzy

 

[Guest]

Youa re right of course! Thanks for the quick reply!

Suzy,
You wrote

I currently have a query returning birthdays *this* month by using
[Birthdate]=Month(Now())

In order for that to work, Birthdate would have to be a number between 1
and 12. If that's true, then...
[Birthdate] = Month(DateAdd("m",1,Now()))

If Birthdate is actually a legitimate date (mm/dd/yy) then I think you
want...
Month([Birthdate]) = Month(DateAdd("m",1,Now()))
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi team!

I currently have a query returning birthdays *this* month by using
[Birthdate]=Month(Now()).

How do I modify this to return the birthdays for *next* month?

Many thanks in advance,
Suzy