Run a report based on a 1 month range

[Andrew]

How do I set up a report that runs after the user selects a month,
(from a combo or list box on a form) so that the only data in the
report is data from the month selected? I'm not too good with VBA
code, but I can copy/paste and edit to my needs fairly well.

Thanks!
Andrew

[Bas Cost Budde]

Andrew wrote:

How do I set up a report that runs after the user selects a month,
(from a combo or list box on a form) so that the only data in the
report is data from the month selected? I'm not too good with VBA
code, but I can copy/paste and edit to my needs fairly well.

Is the report based on a query? If not, create a query. Include a new
field, with this expression:

theMonth: forms!yourFormName!yourComboboxOrListName

in the criteria linethe date as field, and put this in the criteria line:

Is Null or month(nameOfYourDateField)

This is from the top of my head
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea