query

  • Thread starter Thread starter Deborah
  • Start date Start date
D

Deborah

I have a table created with information that I need
printed out in a report sorted by a field called "zone".
I also want only records greater than a certain number
each time I run the report. I want to create a query
that asks me for the zone # I want each time I run the
report. I think I can do this in the query, but am
unsure how. I also want three records to print on each
page (I know that there is enough room to do this). I
think what I am supposed to do is open a new report using
the query I have created and then lay out the fields in
the format I want. I need the above questions answered
and any other basic information regarding queries and
reports. Thanks!
 
Make a parameter query to handle the zone #. Create new
query, selecting the fields that you want. In the
criteria section for zone #, type something like >[Enter
Zone #]

This will prompt you to enter a zone #. And the query
will only select those with a zone # greater than the #
that you entered.

This should get you started.
 
Back
Top