Retrieve the S&S In-Chapter Database

profilexoon
ss_in-chapter_database.accdb
Home>Business & Finance homework help>Accounting homework help>Retrieve the S&S In-Chapter Database
Customer # Customer Name Street City State
151 D. Ainge 124 Lotus Lane Phoenix AZ
152 G. Kite 40 Quatro Road Mesa AZ
153 F. Roberts 401 Excel Way Chandler AZ
Item # Unit Price Description
10 499 Television
20 699 Freezer
30 899 Refrigerator
40 789 Range
50 449 Microwave
Sales Invoice # Date Salesperson Customer #
101 10/15/15 J. Buck 151
102 10/15/15 S. Knight 152
103 10/28/15 S. Knight 151
104 10/31/15 J. Buck 152
105 11/14/15 J. Buck 153
Sales Invoice # Item # Quantity
101 10 2
101 50 1
102 10 1
102 20 3
102 30 2
103 50 2
104 40 1
105 10 3
105 20 1
105 30 2
SELECT Sales.[Sales Invoice #] FROM Sales INNER JOIN [Sales-Inventory] ON Sales.[Sales Invoice #] = [Sales-Inventory].[Sales Invoice #] WHERE (((Sales.Date)>=#10/1/2015# And (Sales.Date)<=#10/31/2015#));