Monday, February 13, 2012

Queries

Contact name and number of companies in the USA?

This was done through creating a query and selecting Product name, Product Number and Country. I wrote USA in the criteria and it showed me the four companies in the USA.
Product names that cost more then $20.00
I did this through creating a query and selecting Product name and Unit Price. I wrote >20 and the query selected all the products that were priced above $20.00
Products with more then 30 items in stock-

I did this through creating a query and selecting Product name and Units in stock. I wrote >30 in the criteria and the query selecting all the products with more then 30 units in stock.

No comments:

Post a Comment