Selecting only one month for a report

[Jack Garabito]

Hello all,

I have a birthday report from a query ³Birthdates² and my report include all
birthdates (Jan-Dec) I only want to display on the report the current (or
selected) month. It is driving me crazy not being able to do so, I can only
run all dates. How can I limit my report to only include the month I select.
Am I doing my report wrong? Should I run a different query selecting only
one month, then run my report off that query? Is there a more efficient way
to get the results I like?

Thank you all.

JG

 

[Evi]

Selecting only one month for a reportLets say your birthdate field is called
BDate

In the Criteria line of the query under BDate type

=Month(Date())

to get birthdays in the current month.

If you want to know what month number a birthday is in you can type
BMonth: = Month(BDate)


I've just done one of these Birthday database myself and have worked out
that I need shares in Hallmark to cope with the cost of cards!

Evi
Hello all,

I have a birthday report from a query "Birthdates" and my report include all
birthdates (Jan-Dec) I only want to display on the report the current (or
selected) month. It is driving me crazy not being able to do so, I can only
run all dates. How can I limit my report to only include the month I select.
Am I doing my report wrong? Should I run a different query selecting only
one month, then run my report off that query? Is there a more efficient way
to get the results I like?

Thank you all.

JG

 

[John Spencer]

Add a calculated field to your query

For the current month:
Field: JustTheMonth: Month([BirthDate])
Criteria: Month(Date())

You specify the month number when the report runs
Field: JustTheMonth: Month([BirthDate])
Criteria: [Enter month number 1-12]

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================