Case insensitive join

B

Bob Peskin

How can do a case-insensitive join on 2 tables in Access 2k.

Example of keys are:
210(,dk
210(,Dk
210(,dK
and Access query builder sees these as being the same value.
 
G

GreySky

Ooops, little problem with my expression. This is
updated...

format(asc(Left(strdata, 1)),"000") & format(asc(mid
(strData, 2, 1)),"000") & format(asc(mid(strData, 3,
1)), "000") & format(asc(mid(strData, 4, 1)), "000") &
format(asc(mid(strData, 5, 1)), "000") & format(asc(mid
(strData, 6, 1)),"000") & format(asc(mid(strData, 7,
1)), "000")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

More than one criteria value in a query 2
Delete query based on criteria HELP! 2
Conditional formatting with vba 3
Update query problem 6
Sum one field if another field is equal to something 10
MACRO TO WORKOUT PERCENTAGE 0
PLEASE CAN ANYBODY HELP - MACRO NEEDED 2
Macro to copy and populate an egsisting ssheet and save it. 1

Top