Setting up Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 
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]
 
Back
Top