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.