I am trying to parse out data that was imported from an EXCEL file. (I still use MS OFFICE 2003). I have succeeded in parsing out the desired data into a single word field (in title case, all lower or all upper case and or a mix of them that I want to update to a separate field in the database. I can sort on this field in a query OK as well as doing a "Find" using the drop down window.
However, my problem is when I try running a query using the the "Contains" line, the selection e.g. "A" always fails. I have attempted various values, such as chr(65), asc(65) and 65 with an without quotes. I just cannot figure out the syntax to put in the "Contains" line, if indeed I can select a title case value. So far my only solution is to copy the value in a computed field (using Right, Left, Instr and Mid functions in several steps). This is a lot of work that involves about 6000 records.
Any help/suggestions would be appreciated.
KRoger