Case Sensitive Matching

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susy - 27 Mar 2008 20:32 GMT

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,

Reply to this Message

KARL DEWEY - 27 Mar 2008 22:40 GMT

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))

Signature

KARL DEWEY
Build a little - Test a little

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks,

Reply to this Message

Susy - 28 Mar 2008 15:17 GMT

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,

> There is probably an easier way but you can parse the code and determine the
> ASCII code for the comparrion.
[quoted text clipped - 12 lines]
> >
> > Thanks,

Reply to this Message

KARL DEWEY - 28 Mar 2008 16:22 GMT

>>a 4 digit code for each user id of mine.

You post had a two digit code - AA, Aa, aa, BA, Ba, etc.

>>But now I'm having trouble linking this 4 digit code to another table

Build a query per table to output the calculated field and then join them in
a third query.

Signature

KARL DEWEY
Build a little - Test a little

> 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
[quoted text clipped - 20 lines]
> > >
> > > Thanks,

Reply to this Message