M
micfly
Still confused - beginner
Trying to build a query to show total "New Retail" sales.
Sounds simple but I can't figure it out. The records are stored in the
table: TblTracking.
The "New Retail" is one option selected from a combo box in the main form
where all the sales data is entered. New Retail is stored in the "Tracking"
field in the TblTracking table. It's pulled from another table in the combo
box so New Retail is stored as the ID# e.g. New Retail is "1" in the
Transaction field in TblTracking. (Sorry for the long wind).
I tried this (sql view):
SELECT TblTracking.Transaction, TblTracking.DealNumberID
FROM TblTracking
GROUP BY TblTracking.Transaction, TblTracking.DealNumberID
HAVING (((TblTracking.Transaction)="1"));
That gives me the deal records when I when I open the query but I want the
total of the deals. Adding SUM doesn't work?
How do I do this? Thanks!
Trying to build a query to show total "New Retail" sales.
Sounds simple but I can't figure it out. The records are stored in the
table: TblTracking.
The "New Retail" is one option selected from a combo box in the main form
where all the sales data is entered. New Retail is stored in the "Tracking"
field in the TblTracking table. It's pulled from another table in the combo
box so New Retail is stored as the ID# e.g. New Retail is "1" in the
Transaction field in TblTracking. (Sorry for the long wind).
I tried this (sql view):
SELECT TblTracking.Transaction, TblTracking.DealNumberID
FROM TblTracking
GROUP BY TblTracking.Transaction, TblTracking.DealNumberID
HAVING (((TblTracking.Transaction)="1"));
That gives me the deal records when I when I open the query but I want the
total of the deals. Adding SUM doesn't work?
How do I do this? Thanks!