|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 2nd, 2006, 08:26 PM
posted to microsoft.public.access.queries
|
|||
|
|||
YTD
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? -- Jess 
|
|
#2
March 2nd, 2006, 08:57 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
YTD
When I do a crosstab query it causes problems with the date field because I
query this information for the report. -- Jess "Jessaudrey" wrote: 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? -- Jess
|
|
#3
March 2nd, 2006, 09:07 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
YTD
On Thu, 2 Mar 2006 12:26:31 -0800, "Jessaudrey"
wrote: 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]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
