Query totals for several items

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

Carol Spurgeon

okay, I admit I'm a novice. I have created a table with:
Listing Agent, Sales Agent, Sales Price and Commission.
I input each agents information into the table. Then, I
created a query that I ask "who for" and type in the name
of the individual agent. I pull up their sales and
commission information. I want to have a running total
on these two items; i.e. sales price and commission. I
want to be able to pull their information up and give
them a total at any given time. I cannot seem to get
these to add a column. Maybe I can't do it in a query.
but if I do it in a form---how? Thanks for any help.
 
Carol,

First point is... generally the purpose of a query is to define a set of
dat which can then serve as the recordsource, or part of the
recordsource of a form or report. Normally, the results of a query are
not directly accessed... that's just how Access works best.

Having said this, you can use a query to get totals. Depends whether
you want your form or report to see the individual items as well as the
totals, or just the totals. To make a Totals Query, select Totals from
the View menu in query design view. In this case, you would leave Group
By in the Listing Agent and Sales Agent columns, and put Sum in the
Sales Price column. I am a bit confused about the Commission... is this
a percentage figure? But if you also want to see the individual items,
make a continuous view form based on the query (without Totals), and
then in the form footer put an unbound textbox, with its COntrol Source
property set to =Sum([Sales Price])

Anyway, hope that helps get you going in the right direction.
 
Back
Top