- Write a query to display the customer code, balance, and total purchases for each customer. Total purchase is calculated by summing the line subtotals for each customer.
- Create a query to produce the total purchase per invoice and sort by Invoice Number. Invoice total is the sum of the product purchases in the LINE that corresponds to the INVOICE.
- List the balances of customers who have made purchases during the current invoice cycle-i.e. for the customers who appear in the INVOICE table. Sort by Customer Code (CUS_CODE).
CUSTOMER Access Table Tools Help g Selection ing Advanced Tell me what you want to do ac Replace Arial aeSpelling X Delete-B More. More | Find GoTo Select Size to Switch | B 1 u | A..ay. 2, Fit Form Windows Refresh Toggle Filter | Sort Filter Records Find Window Text Formatting 4-2573 894-1238 894-2285 894-2180 222-1672 442-3381 297-1228 290-2556 382-7185 297-3809 10010 10011 Dunne 10012 Smith 10013 OlowskiPaul 0.00 345.86 536.75 713 Leona Kathy 10014 Orlando 615 713 615 615 713 615 Myron 10015 O'BrianAmy 10016 Brown 10017 Wiliams George 10018 Farriss 10019 Smith 0.00 221.19 768.93 216.55 0.00 James Anne Olette New tals E SaveSpellingFind lection Hac Replace Ascending Descending Remove Sort Y Toggle FilterAlDelete " More Arial anced Go To Size to SwitchB | Fit Form Windows Refresh k Select . Find Sort & Filter Records Window INV NUMBE -cUs cO-IINV DATI - Click to Add 002 1003 1004 10014 16 Jan-16 10011-16-Jan-16 10012 16-Jan-16 10011 17 Jan-16 1005 10018 17-Jan-16 1006 1007 1008 10014 17-Jan-16 10015 17 Jan-16 10011 17 Jan-16 Tools Help Fields Table ng Y Selection External Data B me what you Totals ab New Replace | | Arial lin!! Descending t-Advanced- ze Remove Sort Spelling | Find Save Remove Sort Toggle Filter | RetresnXDelete '-Mor Select. | Fit Form Windows Size to Switch BIL inter e Sort & Filter Records Find Window INV NUMBI | LINE-NUM BE | P-CODE-I LINE-UNIT. I LINE PRIC -Click to ICCD 10012 23109-HB 1002 1003 1003 1003 1004 1004 1005 1006 1006 1006 1006 1007 1007 1008 1008 1008 9.95 2 4.99 1 54778-2T 12238/QPD 2 1546-Q02 3 13-02/P2 38.95 39.95 14.99 4.99 9.95 5.87 36.99 109.92 9.95 256.99 14.99 4.99 5.87 119.95 54778-2T | 2 23109-HE 1 PVC23DRT 1 SM-18277 22232/QTY : 3 23109-HB 4 89-WRE-Q 13-Q2/P2 2 54778-2T 1 PVC23DRT 2 3 23109-HB 9.95 0.00 Selection Advanced Toggle FilterAuYDelete .. Morer .otals W Speling ac Replace Go To Select Descen Refresh A Size toSwitch Fit Form Windows Find Remove Sort Y Toggle Filter Find PART PRIC-IV COC- Sort & Filter Records Window PART DESCRIPT 109.99 25 14.9921 A n13 02/P2725Hin. pwr saw blade 1344 17.49 21344 3995 23119 43.99 23119 24288 99.87 24288 38.9525595 9.95 21225 4 012439.00-in. pwr saw blade 1546 002Hrd. cloth, 1/4Lin. 2x50 1558-QW1Hrd. cloth, 1/2-in., 3x50 2232/QTY B&D jigsaw, 12-in. blade- 2232/QWE B&D jigsaw, 8-in. blade 2238/QPDB&D cordless drill 112 in. 23109-HBClaw hammer 23114 AASiedge hammer, 12b 54778-2T Rat-tail file, 1/8-in. fine 89-WRE-Q Hicut chain saw 16 in PVC23DRTPVC pipe, 35-in. 8-ft SM-18277 1.25-in. metal screw 25 SW-23116 2.5-in. wd. screw 50 WR3TT3Steel matting 4'x8'x1/6 5" mesh . 109.92 14.4 4.99 21344 256 99 24288 5.87 699 21225 8.45 21231 11995 25595 dingAdvanced gcdReaveSellingAvial Sort Toggle Filter | 'Ali-X Delete More , Refresh Find, o SelectFit Form Windows v 11 mil size to Switch | B 1 u A'.2, & Filter Records Find Windoww Text Formattin P. CODE 11QER/31 E 13-Q2/P2 7.25-in. pwr. saw blade 14-01/L3 9.00-in. pwr. saw blade P DESCRIPT 13-Dec-15 13-Nov-15 15 14.99 17.49 839.95 5 43.99 5 109.92 99.87 5 38.95 9.95 02-Jan-168514.40 4.99 5 256.99 5.87 01-Mar-16172756.99 8.45 32 18 0.05 21344 0.00 21344 12 15Jan-16 15 E1546-002 Hrd. cloth, 1/4-in., 2x50 :1558-QW1 Hrd. cloth, 1/2-in., 3x50 2232/QTY B&D jigsaw, 12-in. blade : 2232/QVVE B&D jigsaw, 8-in. blade 0.0023119 15-Jan-16 30-Dec-15 24-Dec-15 20-Jan-16 20-Jan-1 23 8 0.00 23119 0.05 24288 0.05 24288 0.05 25595 0.10 21225 0.05 0.00 21344 0.05 24288 2238/QPD B&D cordless dril, 1/2-in 23109-HB Claw hammer 12 23 23114-AA Sledge hammer, 121b. Rat-tail file, 1/8-in. fine 54778-2T 89-WRE-Q : Hicut chain saw, 16 in. PVC23DRT PVC pipe, 3.5-in., 8-ft SM-18277 15-Dec-15 4320 07-Feb-16 20-Feb-1618875 125-in. metal screw, 25 21225 24-Feb-16 237100 SW-23116 2.5-in. wd. screw, 50 H WR3TT3 Steel matting, 4x8x1 0.0021231 0.10 0.00 16 5" mesh 17-Jan-16 185 119.95 25595 BleT Tell me what you want to do Selection ac Replace Arial SaveSpelling X Delete More Refresh Size to Switch | Blu A. 2. rtToggle Filter Select Fit Form Windows Records Find Window Text Formatting P DESCRIPT 13-Q2/P2 7.25-in. pwr. saw blade 14-Q1/L3 9.00-in. pwr. saw blade 1546-002 Hrd. cloth, 1/4-in., 2x50 1558-QW1 Hrd. cloth, 1/2-in., 3x50 2232/QTY B&D jigsaw, 12-in. blade 2232/QWE B&D jigsaw, 8-in. blade 2238/QPD B&D cordless drill, 1/2-in. 23109-HB Claw hammer 23114 AA Sledge hammer, 12 Ib 54778-2T Rat-tail file, 1/8-in. fine 89-WRE-Q Hicut chain saw, 16 in. PVC23DRT PVC pipe, 3.5-in., 8-ft SM-18277 1.25-in. metal screw, 25 SW-23116 2.5-in. wd. screw, 50 WR3/TT3 Steel matting, 4x8x1/6", 5" mesh 0.05 21344 13-Dec-15 13-Nov-15 15-Jan-16 0.00 21344 0.00:-231192 0.00 23119 0.05 24288 1 15-Jan-16 23 30-Dec-15 24-Dec-1565 99.87 20-Jan-161238.95 20-Jan-16 23109.95 02-Jan-16 15-Dec-15 07-Feb-16 20-Feb-16188 75 01-Mar-1617275 24-Feb-16 237 100 5 109.92 0.05 24288 1 0.05 25595 0.10 21225 0.00 21344 0.05 24288 2 5 256.99 0.00 21225 0.00 21231 0.10 25595 17-Jan-16 18 New Totals Arial Adv Toggle Filter All shX Delete More Fit Form Windows Window Records Find Text Formatting P CODE P DESCRIPT 13-02/P2 7.25-in. pwr, saw blade 14-Q1/139.00-in. pwr. saw blade 1546-002 Hrd. cloth, 1/4-in., 2x50 1558-QW1 Hrd. cloth, 1/2-in., 3x50 2232/QTY B&D jigsaw, 12-in. blade 2232/QWE B&D jigsaw, 8-in. blade 2238/QPD B&D cordless drill, 1/2-in 23109-HB Claw hammer 23114-AA Sledge hammer, 12 lb. 54778-2TRat-tail file, 1/8-in. fine 89-WRE-Q Hicut chain saw, 16 in. PVC23DRT PVC pipe, 3.5-in., 8-ft SM-18277 1.25-in. metal screw, 25 SW-23116 2.5-in. wd. screw, 50 WR3/TT3 Steel matting, 4x8x1/6" S mesh 13-Dec-15 13-Nov-15 15-Jan-16 15-Jan-16 0.0521344 2 0.00 21344 2 0.00 23119 2 0.00 23119 39.95 109.920.05 24288 1 0.05 24288 2 0.05 25595 1 0.10 21225 1 24-Dec-15 20-Jan-16 20-Jan-1623 10 02-Jan-16 15-Dec-15 07-Feb-1611 20-Feb-16 18875 01-Mar-16172 75 24-Feb-16 237100 5 99.87 5 38.95 0.00 21344 2 0.05 24288 1 5 256.99 0.00 21225 0.00 21231 0.10 25595 1 17-Jan-16 18 5119.95 Table Tool PRODUCT initial Access Briana Database Toolslp Fields Table Tell me what you want to do Ascending T, selection Descending Advanced- Rem ove Sort Toggle Filter | 'Al-X Delete More , ebc Replace Totals Spelling | Find CS Select" | Fitro indow Arial Go To Refresh Select- Fit Form windows . Sort & Filter Records Find Text Formatting P DESCRIPT 11QER/31 109.99 0.00 25595 0.05 21344 0.00 wer A 13-02/P2 7.25-in. pwr. saw blade 13-Jan-1632 15 1499 0.00 evised Access Briana Ferrucci _ Database Tools Help Fields Table Ascending Selection DescendingAdvanced- Remove Sort Toggle Filter Tell me what you want to do lotals e E. Save | ketres"X Delete 8 Spelling | ind | Blu A...-2 | Size toSwitch SelectFit Form Windows- Find More Sort & Filter Records P DESCRIPT Windovw Text Formatting 13-02/P2 7.25-in. pwr. saw blade 14-0113 9.00-in. pwr. saw blade 1546-Q02 Hrd. cloth, 1/4-in., 2x50 1558-QW1 Hrd. cloth, 1/2-in., 3x50 2232/QTY B&D jigsaw, 12-in. blade 2232/QWE B&D jigsaw, 8-in. blade 2238/QPD B&D cordless drill, 1/2-in. 23109-HB Claw hammer 23114-AA Sledge hammer, 12b 54778-2T Rat-tail file, 1/8-in. fine 89-WRE-Q Hicut chain saw, 16 in PVC23DRT PVC pipe, 3.5-in., 8-ft SM-18277 1.25-in. metal screw, 25 SW-23116 2.5-in. wd. screw, 50 WR3/TT3 Steel matting, 4x8x1/6", 5" mesh 17-Jan-16 13-Jan-16 13-Jan-16 18 15-Jan-16 0.00 21344 39:95 0.00 23119 0.00 23119 0.05 24288 0.05 24288 0.05 25595 0.10 21225 5 109.92 20-Nov-15 20-Jan-16 231 02-Feb-16 15-Jan-16 07-Dec-15 0J-161875 5.87 0.00 29-Dec-15 172 75 6.99 24-Dec-15 237 100 845 14.40 0.00 21344 0.05 24288 2 0.00 21225 0.00 21231 0.10 25595 18 5 119.95 Search Caps Lock AB
