G
Guest
My brain has short circuited for today and I can't think. Any help would be
much appreciated.
I want to create a query (i guess) to:
1) multiply 1 column w/another giving me a total for each ITEM (I.e.
QTYxCOST/UNIT)
2) add totals for each ITEM by CODE group
I was able to create a query for task #1. I'm just stuck on #2
SAMPLE OF DATA TABLE
CODE SUBCODE ACTIVITY DESCRIPTION QTY UNIT COST/UNIT
1000 GENERAL REQ.
1000 001 Superintendant 320 HR $60.00
1000 002 Project Manager 103 HR $50.00
2000 DEMOLITION.
2000 001 1st fl trash removal 12 HR $50.00
much appreciated.
I want to create a query (i guess) to:
1) multiply 1 column w/another giving me a total for each ITEM (I.e.
QTYxCOST/UNIT)
2) add totals for each ITEM by CODE group
I was able to create a query for task #1. I'm just stuck on #2
SAMPLE OF DATA TABLE
CODE SUBCODE ACTIVITY DESCRIPTION QTY UNIT COST/UNIT
1000 GENERAL REQ.
1000 001 Superintendant 320 HR $60.00
1000 002 Project Manager 103 HR $50.00
2000 DEMOLITION.
2000 001 1st fl trash removal 12 HR $50.00