By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,009 Members | 1,767 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,009 IT Pros & Developers. It's quick & easy.

Report all records with date of same month

P: n/a
Hi All,

I want to create a report listing all the people's birthdays that are in
the current month, in other words, if I clicked to open the report
today, it would show everyone who's birthday is in september.

I would then want to maybe show only people who are turning 21, or 50,
or whatever age I input.

Any idea's anyone?

TIA

Alec Christie
alec_e_christie(at)hotmail(dot)com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Create a query to base your report on. Make one of the query fields
Month(DOB) and include the other fields you want in the report. Use the
following expression for the criteria of the Month(DOB) field:
Month(Date())

Your query will return everyone who has a birthday in the current month.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Alec" <alec_e_christie at hotmail dot com> wrote in message
news:41**********************@news.newsgroups.ws.. .
Hi All,

I want to create a report listing all the people's birthdays that are in
the current month, in other words, if I clicked to open the report
today, it would show everyone who's birthday is in september.

I would then want to maybe show only people who are turning 21, or 50,
or whatever age I input.

Any idea's anyone?

TIA

Alec Christie
alec_e_christie(at)hotmail(dot)com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #2

P: n/a
Alec wrote:
Hi All,

I want to create a report listing all the people's birthdays that are in
the current month, in other words, if I clicked to open the report
today, it would show everyone who's birthday is in september.

I would then want to maybe show only people who are turning 21, or 50,
or whatever age I input.

Any idea's anyone?

TIA

Alec Christie
alec_e_christie(at)hotmail(dot)com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


You could create a filter. For example, lets say you have a field in
the report called BD (birthday). You want to select records for the
current month. And you want the age to be 50

Dim strWhere As String
strWhere = "(Month(BD) = Month(Date())) And " & _
"(Year(date()) - Year(BD) = 50)"
Docmd.openreport "ReportName",,,strWhere
IOW, if you can create a WHere clause string prior to calling the
report, that'd be your best option.

Nov 13 '05 #3

P: n/a
Thanks guys, I was going about it the wrong way, I was trying to create
a query, which got confusing, the where clause worked a treat tho.

Thanks again!

Alec Christie
alec_e_christie(at)hotmail(dot)com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.