Querie Usage

[Guest]

How do I get a querie to ask me for the range or specific label to search
for? I have a table with 074-I-05, 078-I-05, 071-I-05, etc and for each one
there are a set of recommendations and questions. how do I get the querie to
give me only the information for say 074-I-05?

Thanks

David

 

[Douglas J Steele]

When you're creating the query, put a Criteria of "074-I-05" for whichever
field contains that value.

 

[Guest]

But what if I want a different set each time? Say, I run the querie and this
time want 074-I-05 but next time want078-I-05. Is there a way that I can get
it to prompt me for this information?

 

[John Vinson]

But what if I want a different set each time? Say, I run the querie and this
time want 074-I-05 but next time want078-I-05. Is there a way that I can get
it to prompt me for this information?

Two ways:

Use a criterion of [Enter ID to display:]

The user will get that as a prompt; if they type 078-I-05 they'll see
the results for that value.

Better:

Create a little form named frmCrit. On it, put a combo box cboID,
displaying all of the valid codes (based on a query of your table).
Use a criterion

[Forms]![frmCrit]![cboID]

The user will be able to *pick* a valid ID from the list, rather than
having to type every one and not make any typos.

You can base a Form (for onscreen display) or Report (for printing) on
the query, and have a command button on frmCrit to open these. The
user won't need to see the query datasheet at all.

John W. Vinson[MVP]