Each year our client's auditors ask for a schedule of remuneration and travel costs for key staff.

How would you go about creating a Gridview view that would query the user for the range of accounts you wish to search for a particular text string? Example: I wish to search all accounts from 8000 to 9999 for the text string "Lyndon"

This search would be on the Ledger database.

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.

Hello Lyndon:

I should add that the example above assumes GL 9.0A or B. If you are using 8.1, remove the reference to Description 2.

I am impressed. It worked on the first attempt! Thanks Bruce!

Is there a way for it to not be case sensitive? I remember Andrew mentioning that you can force the results of a search into Upper Case somehow.

Thanks Bruce,

I was just waiting until I powered up my laptop, but you beat me to it!

FIND formula above uses the UPPER() formula so it finds everything.

David

Hi Lyndon:

The search doesn't care whether you use upper or lower case. You'll see that the UPPER() function is used to convert both what the user types in and what is contained in the 2 Description fields. That way apples are compared to apples.

I should have said "not case sensitive" rather than "case insensitive" earlier. I thought of that at the time, but it was late & I was tired!

That is what I thought the "UPPER" meant. Thanks again