Software

Ask something
Discussion Locked

Case Sensitivity in Queries for Access

0 helpful
3 replies

by pclough

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When entering criteria for text field searches how do you overcome the Caps versus lower case and not getting both Such as search for
"*PrintNow*" versus just type "*printnow*" and being able to get all instances of PrintNow even those expressed in all lower case letters?

3 replies

by pclough

Since I am using the Query Wizard how do I enter the info I am looking for? In place of the word name in brackets? Would I type just printnow or 'printnow' or what syntax?

by dklippert

Do you want PrintNow and printnow ? If so just type in the Criteria box in Design view.
You might also want to look up Parameter Query in the Help file.

This discussion is closed to new replies.