I need help creating a cross tab query

Walt uue for each sales rep. Views Sort & Filter Redd Jep 10 Query 11. Create the crosstab query Clipboard shown in Figure 2-90. The State-Sales Rep Crosstab crosstab groups the average State - Total of Am of customers' amount paid by $1,431.38 state and sales rep number. $2,503.57 $1,717.10 Save the crosstab as State-Sales Rep Crosstab. 12 26 DE NU 29 $537.50 $2,285,50 $1,572.50 $2,352,61 $1,190.00 PA 32 $2,325.25 $3,325.45 $2.125.25 B Copy Format Painter Sore O Calibri Clipboard ss Obje.... p Database Mgt Lab 1 Garden Naturally - Deine Maloracedo Acces Table Tell me what you want to do 1 Ascending T Selection Nes 9 Totals Replace Filter A. Descending Advanced Beesh Speling Go To 11 HEE 2 Remove Sort Y Toggle Filter Find A X Delee More Select IWA.EE Ricos Fund LE Customer X Sales Rep X et foring CUE Customer Name Address City State. Postal Code Amount Paid - Balance Due SRClick to Add AA3d All About Gardens 47 Berton St. Greer PA 19155 Christmas Tree Farm $1,190.00 CTO2 $385.00 26 483 Cantorid Pleasantburg NU 07025 $2,285,50 GG01 Garden Gnome $825.35 23 10 Main St. Gossett 19157 $12000 $297.50 23 GT34 Green Thumb Growers 26 Jefferson Hwy. Pleasantburg N 07025 $1325.45 $865 50 12 LH15 Lawn & Home Store 33 Maple St. Chambers N 07037 S5.00 $515.00 25 ML25 Mum's Landscaping 196 Uncoln Ave Quaker DE 19719 $0.00 $1.805.00 29 0445 Outside Architects 234 Magnolia Rd. Gaston DE 19723 $4,205.50 $94.00 12 PLIO Pat's Landscaping 22 Main St. Cheunge NI 1053 $1,165.00 $180.00 25 PN18 Pyke Nurseries 10 Grant Blvd Adelphia 19159 $2.465.00 $530.00 32 SL25 Summit Lawn Service 345 Oaktree Rd. Chenee NU 0053 $225.45 $673.50 26 TG38 TriState Growers 24 Main St. Gaston DE 19723 $1,075.00 $0.00 29 TW34 TAL Wholesalers 234 Cantor Rd. Pleasantburg N 07025 $4,125.00 TYO3 TLC Yard Care 24 Berton St. Greer PA 19159 $1.365.00 $9.45 29 Yard Shoppe 1:34 Elm St. 7504 Quaker DE 19719 $445.00 $575.00 12 PA $125.50 19156 SM45.50 12 vwoi Young's Wholesalers 5239 Lancaster Hwy. Adelphia 8 + Query Step 7 Query Step Ouen Step 4 Query Step 5 Query Step 1 Step 10 Ouery Step 2 Step 3 er Step Suey Ste 9 Query iningai Root Walt uue for each sales rep. Views Sort & Filter Redd Jep 10 Query 11. Create the crosstab query Clipboard shown in Figure 2-90. The State-Sales Rep Crosstab crosstab groups the average State - Total of Am of customers' amount paid by $1,431.38 state and sales rep number. $2,503.57 $1,717.10 Save the crosstab as State-Sales Rep Crosstab. 12 26 DE NU 29 $537.50 $2,285,50 $1,572.50 $2,352,61 $1,190.00 PA 32 $2,325.25 $3,325.45 $2.125.25 B Copy Format Painter Sore O Calibri Clipboard ss Obje.... p Database Mgt Lab 1 Garden Naturally - Deine Maloracedo Acces Table Tell me what you want to do 1 Ascending T Selection Nes 9 Totals Replace Filter A. Descending Advanced Beesh Speling Go To 11 HEE 2 Remove Sort Y Toggle Filter Find A X Delee More Select IWA.EE Ricos Fund LE Customer X Sales Rep X et foring CUE Customer Name Address City State. Postal Code Amount Paid - Balance Due SRClick to Add AA3d All About Gardens 47 Berton St. Greer PA 19155 Christmas Tree Farm $1,190.00 CTO2 $385.00 26 483 Cantorid Pleasantburg NU 07025 $2,285,50 GG01 Garden Gnome $825.35 23 10 Main St. Gossett 19157 $12000 $297.50 23 GT34 Green Thumb Growers 26 Jefferson Hwy. Pleasantburg N 07025 $1325.45 $865 50 12 LH15 Lawn & Home Store 33 Maple St. Chambers N 07037 S5.00 $515.00 25 ML25 Mum's Landscaping 196 Uncoln Ave Quaker DE 19719 $0.00 $1.805.00 29 0445 Outside Architects 234 Magnolia Rd. Gaston DE 19723 $4,205.50 $94.00 12 PLIO Pat's Landscaping 22 Main St. Cheunge NI 1053 $1,165.00 $180.00 25 PN18 Pyke Nurseries 10 Grant Blvd Adelphia 19159 $2.465.00 $530.00 32 SL25 Summit Lawn Service 345 Oaktree Rd. Chenee NU 0053 $225.45 $673.50 26 TG38 TriState Growers 24 Main St. Gaston DE 19723 $1,075.00 $0.00 29 TW34 TAL Wholesalers 234 Cantor Rd. Pleasantburg N 07025 $4,125.00 TYO3 TLC Yard Care 24 Berton St. Greer PA 19159 $1.365.00 $9.45 29 Yard Shoppe 1:34 Elm St. 7504 Quaker DE 19719 $445.00 $575.00 12 PA $125.50 19156 SM45.50 12 vwoi Young's Wholesalers 5239 Lancaster Hwy. Adelphia 8 + Query Step 7 Query Step Ouen Step 4 Query Step 5 Query Step 1 Step 10 Ouery Step 2 Step 3 er Step Suey Ste 9 Query iningai Root