Parameter Query - Force Upper Case

[razorking]

I have a query that is using a linked table for the data source. The query has a field that prompts the user to enter a warehouse code, to look up the records. The data on the source, or linked table, is all upper case. I found that if the user keys the warehouse code in lower case the query returns no results.

I can and have informed the users to key the code for the parameter prompt in upper case but, is there a way to force keyed parameter entry to be in upper case? Or any other way to ensure record return regardless of whether it is keyed in upper or lower case?

Thanks!

 

[jdraw]

You could offer the user a form. Ask /prompt them to enter a warehouse code. Then behind the scene --convert their entry to be Upper Case, then execute the query.

eg. UCase(warehouse code) will produce UPPER CASE version of the entry

Users should be interfacing to the database via a form(s), not query(s) directly.

 

[razorking]

That makes sense. I will give it a go