Year to date totals from quarterly data in same query

[Hakmangv]

how do I calculate the year to date totals from one query for multiple report
dates?
ie total Q1+Q2+Q3 values, some are expression fields and some are just data
fields
thanks!

 

[Jeff Boyce]

Everything starts with the data ...

If you don't give us specifics on what data you have, we're unlikely to be
able to give you specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Duane Hookom]

You can create Year group footers and add text boxes with control sources like:
=Sum([A numeric Field])
If you can't figure this out, you might want to come back with less vague
information like your fields and data types.