Totals in queries

  • Thread starter Thread starter Carol Spurgeon
  • Start date Start date
C

Carol Spurgeon

In my query, I have sales price and commission that I
need totals for. I have right clicked and hit totals,
then sum but am getting nothing when I pull up my query
on each individual. I need running totals so as I enter
more information throughout the year, it will continue to
show a grand total. I picked sales price and commission
from my table. Thanks.
 
-----Original Message-----
In my query, I have sales price and commission that I
need totals for. I have right clicked and hit totals,
then sum but am getting nothing when I pull up my query
on each individual. I need running totals so as I enter
more information throughout the year, it will continue to
show a grand total. I picked sales price and commission
from my table. Thanks.
.
I am not sure if this will help you but I had a similar
Click to expand...
problem with totals. I could not get the query to give
me a running total so after trying there several times
and reading the help section I found that you can produce
a running total in reports. Make the query and make a
field that is a total, in this section use a expression
Total:=[whateverfield] (use the zoom box thats what I
do). Then use this query to make a report. When you have
created the report go to the design view and right click
on the box below the total that you want to make into a
running sum. Select the properties box and set the
running sum to overall. To do this you would select from
a drop down list next to the line that says (running
sum). I hope that this helps you.
Your Welcome
 
In my query, I have sales price and commission that I
need totals for. I have right clicked and hit totals,
then sum but am getting nothing when I pull up my query
on each individual. I need running totals so as I enter
more information throughout the year, it will continue to
show a grand total. I picked sales price and commission
from my table. Thanks.
Click to expand...

Please open your query in SQL view and post the SQL here; and explain
what you mean by "getting nothing".

Generally, you would put Group By on the individual ID (and other
fields pertaining to the individual) and Sum on the fields that you
want to total... but I don't know how your table is structured or how
the query is set up.
 
Back
Top