Hello Lyndon:

Create a View using the "G/L Posted Transactions" table.

Create a filter using the following syntax:
AND(
TRIM({Trx Acct}) >= QUERYSTRING("Starting Account", "1000"),
TRIM({Trx Acct}) <= QUERYSTRING("Ending Account", "9999"),
FIND(UPPER(QUERYSTRING("Search for")), UPPER({Trans Description 1}&{Trans Description 2} ),1 ) > 0
)

You will be asked to enter 3 pieces of information:
-Starting Acct
-Ending Acct
-Text string

The text string search is case insensitive and searches both Description 1 and Description 2.
_________________________
Bruce Gardner
ARX Business Solutions Inc.