Monday, May 26, 2008

How to create a parameter query in Access 2000

How to create a parameter query in Access 2000: "How to create a parameter query in Access 2000"

How to Create a Query with One Parameter
loadTOCNode(3, 'summary');
1.
Start Microsoft Access 2000, and then open the sample database Northwind.mdb.
2.
On the View menu, click Database Objects, and then click Queries.
3.
In the Database window, click the Invoices query, and then click Design.
4.
Type the following line in the Criteria cell for the ShipCountry field. Note that the expression that you enter must be enclosed in square brackets.
[View invoices for country]
5.
On the Query menu, click Run. When you are prompted, type UK, and then click OK to view the results of the query. Note that the query returns only those records whose ship country is UK.
6.
Close the query without saving it.

No comments: