YTD

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

Guest

I Have a table that lists total incoming calls for a week for each agent. I
would like build a report/query that gets year to date information as a
running total. Any suggestions?
 
When I do a crosstab query it causes problems with the date field because I
query this information for the report.
 
I Have a table that lists total incoming calls for a week for each agent. I
would like build a report/query that gets year to date information as a
running total. Any suggestions?
Click to expand...

Use a criterion on your date/time field of

BETWEEN DateSerial(Year(Date()), 1, 1) AND Date()

and make it a Totals query summing whatever it is that you want to
sum.

John W. Vinson[MVP]
 
Back
Top