Can I join on both lower case and upper case in the primary key?

[Guest]

I have a code table that contains a single character as the code, but some
are lower case and some upper case. Access 2003 seems to consider the lower
case and upper case characters as duplicates. I need to join to this table on
this code. Is there a way to tell Access to treat lower case and upper case
characters as unique in a join?

 

[Dave Patrick]

Try adding an expression to your query something to the effect of;

Asc([field1])

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
|I have a code table that contains a single character as the code, but some
| are lower case and some upper case. Access 2003 seems to consider the
lower
| case and upper case characters as duplicates. I need to join to this table
on
| this code. Is there a way to tell Access to treat lower case and upper
case
| characters as unique in a join?

 

[Guest]

If it is a primary key, it is unique. If it's not unique, it's not
a primary key. If you need a primary key field, you need
to use type Binary instead of type Text. (or GUID, or
OLE instead of Memo, but those are bad ideas).

The only way to get a Binary field is using code: ADOX or
DAO or sql ALTER TABLE ADD ..

How To Perform a Case-Sensitive JOIN Through Microsoft Jet
http://support.microsoft.com/?kbid=244693


(david)