finding info on report

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

Guest

I want to be able to search through a report using some kind of edit/find
command. My report is huge w/lots of formulas and do not want to print for
every user. Any help is appreciated!
 
Not sure what you are trying to accomplish.

You don't really explain what you are looking for. If you only wnat to see
certain information on your report, then filter it before you run it so it
only has the pertinant data on it. Don't produce the entire report if you
only need one customer's data.
 
I have it sorted by phone number, but want to be able to put a filter on so I
can type in phone number I want to see. How to I add filter?
 
Well, again, just limit it so it only shows that particular phone number.
Adjust your query to prompt for a phone number and only build the report for
that particular one.

Since it sounds like you are looking for one particular record, I'd probably
do this in a form with a "find" textbox at the top, rather than a report.
 
I created a report from a table. I then added caluculations of percentages on
this report, so I do not have a query or form. Do I need to have a form?
 
You don't a form, but you do need to have it based on a query that will
prompt you for the info you need rather than based on the table which would
give you all the records. For example, if it's a particular phone number you
want put this in the query in that fields criteria:

[Type in Phone Number below]

Then base the report on the query and when it's run it will have a pop up
box that will say "Type in Phone Number below. You type in the number and run
the report and you will see only the records you want.
 
Back
Top