Case Sensitive Matching

  • Thread starter Thread starter Susy
  • Start date Start date
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,
 
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))
 
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...
 
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...
 
Back
Top