merging a common field into one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i'm trying to find the total revenue for each of my employees
right now the query lists each employee hundreds of times for each
transaction they make
how do i get access to add the all the fields which hold the sales amount
for each transaction, and give me one lump sum for each employee?

thanks
 
how do i get access to add the all the fields
What is your table structure like? Do you have multiple fields for the
transactions or multiple records?
You should have the latter like this --
tblSales ---
SaleID - autonumber primary key
Saler - text
SaleDate - datetime
Type - text
Amount - currency

Then you do a totals query grouping on the Saler for SaleDate between the
dates you are interested in.
 
Back
Top