Query search

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

In my drastic search to solve this issue, I finally found
the problem. All the text is UpperCase in the table, and
I need to type this in when searching. However, is there
a way to type in lowercase and still have the correct
result?

Thanks again,
Jim
 
In my drastic search to solve this issue, I finally found
the problem. All the text is UpperCase in the table, and
I need to type this in when searching. However, is there
a way to type in lowercase and still have the correct
result?
Click to expand...

If you're certain that the text in the .dbf file will always be upper
case, use a criterion like

UCase([Enter search term:])
 
Thank you John,
I made that change and it works. I will have to make sure
they use the uppercase.

Jim
-----Original Message-----
In my drastic search to solve this issue, I finally found
the problem. All the text is UpperCase in the table, and
I need to type this in when searching. However, is there
a way to type in lowercase and still have the correct
result?
Click to expand...

If you're certain that the text in the .dbf file will always be upper
case, use a criterion like

UCase([Enter search term:])



.
Click to expand...
 
Thank you John,
I made that change and it works. I will have to make sure
they use the uppercase.
Click to expand...

If you set up a search form, the user need not be concerned about
case... right??
 
Back
Top