Create a Query where in this month all birthday anniversaries in next month are reported

[John Donovan]

My table (tblClients) includes fields [Client Name], Date of birth [DOB].
I wish to contact my clients each year on their birthday anniversary.
I wish to create a report approx. middle of each month of all clients whose birthday anniversaries, say [Anniv], will occur for the full next month.
Example: Mid February this month (say 18th February 2015 which allows me time to analyse March 2015) the report will display all March 2015 birthday anniversaries.
The headings on the report will be [Client Name], [DOB], and presumably an Expression in a third field of a Query.
I presume the Expression will probably include DateAdd() and "m" (for month) but this is where I cannot get the report to work.
All March 2015 (or any other month throughout the year) anniversaries, will display all clients for that month displayed on the report,
BUT if there are no anniversaries, can the report state something like "There are no birthday anniversaries this month"


In the Report Header, (in this example) display "Birthday Anniversary Report for the month of March 2015"
I would like the answer in a Query structure as I am very weak in VBA, but it would also be nice in that style so I can "digest" it for greater knowledge
Thanks in advance

John D

[orange]

To get a list of Clients with Birthdays in the next month
If run in Feb will get clients with Birthdate in March

SELECT * FROM tblClients
WHERE Month([DATE of Birth]) =Month(Date()) +1