Microsoft Access

 different discounts 8 not 6. 

 

First Query per Instructions

  1. Invoice History 

Part 2

Once completed add the following queries to your database.

Create a query for each of the following that shows

  1. How many invoices were paid on time
  2. Which doctor has the most invoices 
  3. Which doctor has the least invoices
  4. How many invoices due after June 30- 2014
  5. How many different doctors offered a discount.
  6. How many discounts were offered altogether. 

Total of 7 Queries for this assignment .

Tags: No tags