W11MGT475Program 8 - H. Klein MGT475 Program 8: Using...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
H. Klein MGT475 Program 8: Using Internal Tables Ziii_P8_SalesAndTables Produce the following report by SELECTing into one or more internal tables that use work areas. Include a Grand Total at the end. Date: 03/21/2011 Sales Report SO Num SO Date Creator Customer Material Description Quantity Total Price 1 1/25/201 1 KLEINH 5 ENSB3000 Entry-Level Skateboard 100 4500.00 2 1/26/201 1 KLEINH 1 ENSB3000 Entry-Level Skateboard 100 4500.00 3 1/27/201 1 DELUCAJ 16 JMD-ENSB3000 Entry-Level Skateboard 69 3105.00 3 1/27/201 1 DELUCAJ 16 JMD-FAID6000 First Aid Kit 69 1104.00 3 1/27/201 1 DELUCAJ 16 JMD-HLMT5000 Helmet 69 1863.00 3 1/27/201 1 DELUCAJ 16 JMD-SHRT4000 T-Shirt 69 690.00 4 1/27/201 1 KUKSC 30 CAK-ENSB3000 Entry-Level Skateboard 25 1125.00 4 1/27/201 1 KUKSC 30 CAK-FAID6000 First Aid Kit 10 160.00 4 1/27/201 1 KUKSC 30 CAK-HLMT5000 Helmet 99 2673.00 4 1/27/201 1 KUKSC 30 CAK-SHRT4000 T-Shirt 14 140.00 5 1/27/201 1 BOBELDYK 14 KJB-ENSB3000 Entry-Level Skateboard 14 630.00 5 1/27/201 1 BOBELDYK
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/05/2011 for the course MGT 475 taught by Professor Klein during the Winter '11 term at Grand Valley State University.

Page1 / 3

W11MGT475Program 8 - H. Klein MGT475 Program 8: Using...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online