Year to date totals from quarterly data in same query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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.
 
Back
Top