Microsoft Office Tutorials and References
In Depth Information
CREATING QUERIES
FIGURE B-44
Deleting all employees who are not Delaware residents
Using Parameter Queries
A Parameter query is actually a type of Select query. For example, suppose your company has 5,000
employees and you want to query the database to find the same kind of information again and again, but about
different employees each time. For example, you might want to query the database to find out how many hours
a particular employee has worked. You could run a query that you created and stored previously, but run it
only for a particular employee.
AT THE KEYBOARD
Create a Select query with the format shown in Figure B-45.
FIGURE B-45
Design of a Parameter query beginning as a Select query
In the Criteria line of the QBE grid for the Employee ID field, type what is shown in Figure B-46.
 
Search JabSto ::




Custom Search