Criteria within a query 1

[Jphillis]

When querying the database I want to be able to type in a particular Client Code within that query so that it produces the information selected for that particular company and only that company. Can anyone help with the criteria needed to do such a thing?

 

[scking]

In the query designer in the criteria row type where the company is listed enter:

[Enter Company Code: ]

Steve King Growth follows a healthy professional curiosity

 

[tempclerk]

In your criteria row, put [Enter Client Code], and you will be prompted for it. I usually prefer to call the query from a form, where you can use a combo box to look up the code by name instead. You would then set the criteria to the value of the combo box (bound to the Client Code column.)