Year to date (Dec - Nov) totals

[criseyde]

I have a monthly report that contains a series of numeric values. I want to add the year-to-date totals for these values to the report (our year runs from December through November). Is there an easy way to add this information to my report? (Should I use a subreport? Do I need to write a second query? Is there another way to do it?)

Thanks for your help,

Criseyde

 

[Trendsetter]

I would be tempted to use a couple of textboxes on a form to set the report dates for you.
You could use a series of option buttons (radio or check) to indicate which report you wish to print and the relevant dates would be coded in the codepage.

The dates would be used in the reqport query against the transaction date or whatever is appropriate and would be used in a Between #Date1# And #Date2# statement

Your year to date would be:
Between #01/12/2002# and Date()

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk