Running Totals / Running Sums

[Jenny]

My boss wants me to tell Him how many total office visits we have made
to various locations by the office visit date.

I have a table "Tbl_Offices" that has uses the "OfficeLocationID" as
the Primary Key. I have another Date Field "OfficeVisit" that i use to
put in the office visit date.

I created a Query that groups by the "OfficeVisit" date field and
Counts the "OfficeLocationID" field to show that we went to so many
offices for that day.

My results look something like this:

OfficeVisit CountOfOfficeLocationID
01/05/05 5
01/06/05 4
01/10/05 6

What I am hoping to achieve and need your help with is creating a
Running Total for the Office Visits.

My results should look like this:

OfficeVisit CountOfOfficeLocationID RunningTotal
01/05/05 5 5
01/06/05 4 9
01/10/05 6 15

I Have been trying DSums and SubQueries have looked at all these posts
but still can't get it to work.

Thanks, Jen

 

[Duane Hookom]

Give the answer to your boss in a report where you can set the running sum
property of a control to either over group or over all.

 

[Jenny]

I will try that but I also need the Running Totals to be used in a
Chart/Graph for a progressive curve line. (So many overall Counts)

Can this be done in a Query? It can be done in Excel but it would save
so much time if it could all be done within Access.

Thanks, Jen