Parameter Query With More Than one Criteria

  • Thread starter Thread starter S Jackson
  • Start date Start date
S

S Jackson

I have two fields: Attny and Assnt. I want the user to run the query
either by selecting an attny or by selecting an assnt. Can I do this in the
query itself, or do I need to build a dialog form and use vb?

TIA
S. Jackson
 
You can do it in the query.
On the criteria line of the Attny field type: Like[Attny]

Then, drop down a row and go to the Assnt field.
On the criteria line type: Like [Assnt]

Make sure the Assnt criteria is 1 line down from the Attny
criteria line.

When the query runs it will request both fields. Just
fill in the info in the field you want to return the info
for.
 
Back
Top