Strange SQL issue
Posted on 2012-04-02
I have a very strange SQL issue in a query.
2 fields exist in a table: EmailFirstName and EmailLastName.
I created a column in the query and concatenated these to fields together.
FullName: [emailfirstname] & " " & [emaillastname]
Notice the e-f-n and e-l-n letters are low case although the table field names are uppercase.
This query works well on PCs from China, Poland, Texas, everywhere in the world but 1 (one) PC err'd on the "emiallastname" part of the concatenated field (in Mexico). PS. Other's in Mexico ran OK, this is just on ONE PC.
I dissected this issue and discovered that as long as the "L" in emaillastname was uppercase, the query WOULD WORK.
Low case in all the other letters worked.
This PC was replaced with a new one (not sure, but probably all existing software replaced also).
I was happy to find, at least, a work-around... but I hate these kinds of mysteries.
Win 7, Access 2010
Can anyone shed any light on this?