It is just a matter of extracting the Year from the date and constructing
the appropriate WHERE clause for the Report's RecordSource. It does require
some VBA.
The Year function extracts the year from a date, for example, try this from
the immediate Window to test.
? Year(#03/15/2002#)
If the records are to be selected from a date field, then you'll have to
extract the Year and put the criteria on that calculated field.
Larry Linson
Microsoft Access MVP
"DD" <da**********@bigpond.com.au> wrote in message
news:14**************************@posting.google.c om...
I have a mainForm with a subForm
On the main form i have a combo with March 04, April 04 etc, you
select a date and the subform shows all records for the selected date.
I can print a selected record, how ever i want to print all the
records for the month selected.
Can anyone advise please
Regards
DD