Rpt prompt for "Contain part of field" etc

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

Guest

Easy Fix for you

I need to set up a report thats main grouping/sorting is on the Map page # corresponding with the Thomas Guide for our area

How do I set up a prompt upon opening the report that will ask for the page number of the guide so that I only get the clients that live on that page. It would need to query part of a field. The client may live in 474 H-4 etc, but I want all clients on page 474

Thanks in advance
 
Rene:

You should probably break down the data in your table to the main page
number (e.g. 474) in one field and the sub category (H-4) in another field.
Then in your query for the page field, simply add in the conditions line
something like [Please Enter The Map Page Number].
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

René said:
Easy Fix for you.

I need to set up a report thats main grouping/sorting is on the Map page #
Click to expand...
corresponding with the Thomas Guide for our area.
How do I set up a prompt upon opening the report that will ask for the
Click to expand...
page number of the guide so that I only get the clients that live on that
page. It would need to query part of a field. The client may live in 474
H-4 etc, but I want all clients on page 474.
 
Back
Top