Summing $$ For Multiple POs

[Guest]

I currently have two tables, one for Purchase Details and one for PO General

Purchase Details:

DATE ITEM QTY PRICE PO#

This is joined to the PO table:

PO# TOTAL VENDOR VENDOR TYPE

I would like to be able to query the PO detail table for dollar totals per
PO without repeating the same vendor/po over and over. Plus I could
eliminate the PO table completely, since I'd be able to sum up totals per PO.
Thanks in advance, I'm pretty new at this .

 

[Lynn Trapp]

Select POG.PONumber, POG.Vendor, POG.VendorType, PD.Date, PD.Item,
Sum(PD.QTY)
From POGeneral AS POG join PurchaseDetails AS PD on pd.PONumber =
POG.PONumber
Group by POG.PONumber, POG.Vendor, POG.VendorType, PD.Date, PD.Item;

 

[Guest]

Lynn, thanks. I had no idea what you were telling me to do until I read
something I had downloaded on "how to" and got to the SQL part......Now I
can write my own, woohoo. Thanks again
--
Judy et al
"Love your freedom-thank a veteran"!

Select POG.PONumber, POG.Vendor, POG.VendorType, PD.Date, PD.Item,
Sum(PD.QTY)
From POGeneral AS POG join PurchaseDetails AS PD on pd.PONumber =
POG.PONumber
Group by POG.PONumber, POG.Vendor, POG.VendorType, PD.Date, PD.Item;

 

[Lynn Trapp]

Judy,
You are very welcome... I hope it works for you . If you have any issues,
please feel free to post back.

--

Lynn Trapp
Microsoft MVP (Access)
www.ltcomputerdesigns.com

Lynn, thanks. I had no idea what you were telling me to do until I read
something I had downloaded on "how to" and got to the SQL part......Now I
can write my own, woohoo. Thanks again