Search for Information in a Report

[Ray_Rattler]

We are using Access to print tax forms. One page of the report is devoted to
each record in the database. Sometimes we have around 1000 pages for the
report. Is there anyway to search the report for a particular person. Is
there a way to do this?

 

[Jeff Boyce]

Ray

You have it a bit backwards.

The data is not in the report. The data is in the tables.

The data is DISPLAYED in the report.

Try using a query to get a specific person's data.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[roccogrand]

And if you are running Access 2007 you can type the person's name in the
Search field at the bottom of your data entry form. Access doesn't care if
the characters are upper or lower case and a complete name is optional.
Access will return a filtered list of the records that meet your criteria.

David

 

[Armen Stein]

The data is not in the report. The data is in the tables.

The data is DISPLAYED in the report.

Try using a query to get a specific person's data.

That's true. However, if you really do want to search the
already-formatted report, you could output it to Word or PDF, then
search either of those formats.

If you aren't using a later version of Access that support native PDF
output, then you can use a free PDF print driver like CutePDF.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Jeff Boyce]

Thanks, Armen! I hadn't thought that through to the end...<g>

Jeff B.