Try This: Do the following steps
2. Use the command Create->Query->Query
Design to make a Select Query using the Table tblCustomers.
3. Add the following Fields to the QBE grid: CustomerID,
Company, and Phone.
4. Add a new Concatenated field as follows:
5. Add the following Criteria for the
Company Field: [Enter the Company Name]
6. Run the Query. When prompted for a
Company enter: Wordnation.
7. Save the Query as CustomerCompanySQ.
8. Close all Tables and Queries.
9. Create a new Query with the command
Create->Query->Query Design using the Table tblProducts.
10. Select the following Fields: ProductID,
Type, Item, Specialty, and Description.
11. Add the following Criteria for the Type
field: [Enter a Product Type].
12. Test the Query. When prompted for a
Type enter: Snacks.
13. Save the Query as ProductsbyTypeSQ.
14. Close the Brown Bag database, please. |
|
| |