Solved

Search for text in report.

Posted on 2013-11-25
3
222 Views
Last Modified: 2013-11-25
I've inherited an access database.  it has lots of reports.   I'm trying to find a report some specific text in it.   Is there a way to do search?
0
Comment
Question by:HLRosenberger
3 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 250 total points
ID: 39674983
If the text is in a caption, yes.  The easiest way it to purchase Rick Fisher's "Find and Replace".  This is a great tool and about the best $40 I ever spent.
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 250 total points
ID: 39674987
you have to do a search in the Record Source of your report..

sample query..

select * from TableOrQueryX where [fieldName] Like "* texttosearch *"

"TableOrQueryX" is the record Source of your report, could be a table or a query
0
 
LVL 1

Author Closing Comment

by:HLRosenberger
ID: 39675036
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question