Case Sensitive Matching

S

Susy

Hi,

Hoping someone can help. I've got one table with a list of transactions,
each transaction has a user code assigned to it (i.e. AA, aa, Ab, BA, etc.)
I have another used id table that has the same user codes with a person's
name in another column (i.e. AA John Smith). I'm trying to bring the
person's name into the transaction table to replace the user codes. Is this
possible?

Thanks,
 
K

KARL DEWEY

There is probably an easier way but you can parse the code and determine the
ASCII code for the comparrion.
ASCII_Codes: Asc(Left([user code],1)) & Asc(Right([user code],1))
joined to
ASCII_Codes: Asc(Left([ID],1)) & Asc(Right(Left([ID],2),1))
 
S

Susy

Cool. I've got, from your help, a 4 digit code for each user id of mine.
But now I'm having trouble linking this 4 digit code to another table that
has the person's name and my old user code.

What am I missing.

Thanks,

KARL DEWEY said:
There is probably an easier way but you can parse the code and determine the
ASCII code for the comparrion.
ASCII_Codes: Asc(Left([user code],1)) & Asc(Right([user code],1))
joined to
ASCII_Codes: Asc(Left([ID],1)) & Asc(Right(Left([ID],2),1))

--
KARL DEWEY
Build a little - Test a little


Susy said:
Hi,

Hoping someone can help. I've got one table with a list of transactions,
each transaction has a user code assigned to it (i.e. AA, aa, Ab, BA, etc.)
I have another used id table that has the same user codes with a person's
name in another column (i.e. AA John Smith). I'm trying to bring the
person's name into the transaction table to replace the user codes. Is this
possible?

Thanks,
Click to expand...
Click to expand...
 
K

KARL DEWEY

a 4 digit code for each user id of mine.
You post had a two digit code - AA, Aa, aa, BA, Ba, etc.
Build a query per table to output the calculated field and then join them in
a third query.
--
KARL DEWEY
Build a little - Test a little


Susy said:
Cool. I've got, from your help, a 4 digit code for each user id of mine.
But now I'm having trouble linking this 4 digit code to another table that
has the person's name and my old user code.

What am I missing.

Thanks,

KARL DEWEY said:
There is probably an easier way but you can parse the code and determine the
ASCII code for the comparrion.
ASCII_Codes: Asc(Left([user code],1)) & Asc(Right([user code],1))
joined to
ASCII_Codes: Asc(Left([ID],1)) & Asc(Right(Left([ID],2),1))

--
KARL DEWEY
Build a little - Test a little


Susy said:
Hi,

Hoping someone can help. I've got one table with a list of transactions,
each transaction has a user code assigned to it (i.e. AA, aa, Ab, BA, etc.)
I have another used id table that has the same user codes with a person's
name in another column (i.e. AA John Smith). I'm trying to bring the
person's name into the transaction table to replace the user codes. Is this
possible?

Thanks,
Click to expand...
Click to expand...
Click to expand...
 
Top