Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do I setup a query with I can sort 3 columns for a DVD database with the
3 fields are as follows:
1. Position #
2. Title
3. Movie type

I would like to sort or do a query with I can display only a specific type
of movie with the POS# and the title by like say Sci-Fi and only these types.
I have gone through the tutorials and it seems complicated to me. Please
assist.
 
Hi Scott,
You can create a parameter query - it's a select query that will prompt
you for information, such as movie type.

Select the 3 columns from your table into the query grid. Use the
following syntax in the criteria field for Movie Type:

[Enter Movie Type]

When you run the query, a window will pop up and say Enter Movie Type. If
you type sci-fi, you will get every row from your table where Movie Type is
sci-fi.

Hope this helps
 
Back
Top