Setting up Queries

D

DDrowe

How do I set up a querie to give me only the results from a givin report?
For example - there are 3 sets of recommendations labeled R1, R2 and R3. I
want only the recommendations that are associated with R2.

Thanks

David
 
J

Jerry Whittle

Please provide the names of the table(s) and the required field names in
those tables.

Are R1, R2 and R3 field names or data within one field?
 
D

DDrowe

Actually the Field is PHA Number and some of the PHA numbers are 076-I-05,
074-I-05, 078-I-05, etc. I want to be able to pull all the recommendations
from only 074-I-05.

Thanks

David
 
J

John Vinson

Actually the Field is PHA Number and some of the PHA numbers are 076-I-05,
074-I-05, 078-I-05, etc. I want to be able to pull all the recommendations
from only 074-I-05.
Click to expand...

Create a new Query based on your table.

Type

"074-I-05"

on the criteria line under the PHA Number field.

Base your Report on the query.

Or, better... create a little form named frmCrit. On this form put a
combo box, named cboPHA, listing all of the valid PHA numbers. Make
the criterion

=[Forms]![frmCrit]![cboPHA]

Put a command button on frmCrit to open your Report; the user can
select a PHA number off the list, and then see the report for that
value.

John W. Vinson[MVP]
 
Top