Running Sum Field in a Query

  • Thread starter Thread starter CrossingStreets
  • Start date Start date
C

CrossingStreets

Does anyone know a way to make a running sum field in a QUERY (not a
form or a report) in Access 2003? (If the only answer has to do with
Northwind, can someone point out how to modify it to your own
database??) Thanks!
 
what you'll want to do is right click on the query maker and then click
on the sigma icon (the big funny looking E that says totals).
this brings up anothing 'grouping' line in your query. if you drop down
on that list, you'll see all of the aggregate functions: Sum, count,
Avg, Mean, Max, etc.
hth.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Running Sum Query 1
Parameter Value error in a Subform 0
Sum Fields 2
Running Sum in a Query 1
Sum Query With Parameters 5
Query Sum Amount To Table Field 1
Totaling An Aggregate Expression On A Report 4

Back
Top