Graph help

[Access_help_rob]

Hi there, at the moment i have a graph in access which works out the number of changes made to a certain vehicle in that day for example.
Monday - 5
tuesday -6
wednesday - 4
and so on
However this graph only shows the day to day changes i would like it to work out the total number of changes to date so it would add mon,tue and wednesday together including todays changes as well. i realise this may have to be done in a querie but im not sure how to manipulate the data to get these figures. please help cheers rob

 

[Rich]

Do you have fields named Mon,Tues etc. ? If so you need to normalise the data first

 

[Access_help_rob]

I have contract number as one field this is the vehicles number. i then have a date field next to it (dd/mm/yy format) and number of changes count field next to that.everyday the table gets appended with new data. this table then is used in another query so i can group by vehicle number and it display the dates next to this vehicle number in a separate field and next to that is the number of changes made to that vehicle on that day. I want to be able to show the cumalitive total of changes made to that vehicle.
thanx rob

 

[Rich]

Use a separate query to calculate the total, then use a Union query to join it to the original, assuming I've read this correctly

 

[Access_help_rob]

i can calculate the total how im doing it is i have query which sums up all the counts for that vehicle to date, however i need to work out that for example the counts on the 17th was say 10 and say on the 18th its 5 so on the graph it would show for the 17th 10 counts an for the 18th it would show 15 and so on. please help
rob

 

[Rich]

Search here for Running Sum. Jon K has posted some unique solutions