Running Sum function in query

  • Thread starter Thread starter CC
  • Start date Start date
C

CC

I'm trying to run a sum function in a query and when I click Run it gives me
an error because the table has an *. What does this mean and how do I
correct this?
 
The '*' is used to select all fields. In a totals query (summing) the fields
have to be selected individualy.
 
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
Combine Duplicates in Query 0
SUM in a UNION query 2
Running Sum in query 1
Incorrect sum in MS Access query 1
Running Total - Running Sum 4
calculating running totals 2
Use In() Expression as Query criteria with guts from Function 1

Back
Top