running sum query

[shutzy]

i would like to have a running sum that then updates a tbl.

the running sum must have criteria.

if anyone can give examples then i will be very greatful

im sorry to be so vague but i am not sure what information is needed.

thanks

 

[StarGrabber]

You are "not sure what information is needed" but seem to have a precise idea in your mind. Please explain.

 

[Alansidman]

Why do you need to have a running sum in a table. This is probably not a good idea. It is also a spreadsheet mindset. You can do running sums in queries if the data needs to be presented. Here is a link on how to do running sums in queries. you will have to read through most of the threads to get to the SQL

http://www.mrexcel.com/forum/micros...calculation-based-fields-several-records.html