YTD

[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?

 

[Guest]

When I do a crosstab query it causes problems with the date field because I
query this information for the report.

 

[John Vinson]

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?

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]