Andy said:
All I need it to do is gather all the september dates from
the query and put them on to the september report. Is
there a way to do the on the reports filter?
Possibly, but I think there's a cleaner approach. You
should have a form with a combo box where users can select
the month and a button to print the report. The button
wizard will generate most of the code for you so all you
have to do is modify the code to look more like:
Dim strDoc As String
Dim strWhere As String
strDoc = "nameof report"
strWhere = "Month([datefield]) = " & Me.thecombobox
DoCmd.OpenReport ,acViewPreview, , strWhere
the above presumes that the combobox's bound column is the
number of the month.
