Positioning to certain text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

How do you look at only certain text in a field?

Example: "23AW6GR5TEX" I only want to see the last three which is "TEX".

Thanks
 
Thanks Duane,

Antoher question, is it possible to use the right() in criteria when it is a
field in the table. The "ser1" in the field I'm refering too, it is in the
table.

vSql = "SELECT TASK_NUM, TOTE, DMS_WAVE, STORE_NUM, SER_CNT FROM
VIAWARE_DMSMSG_T WHERE """ & Right(vLkUp, 3) & """ = right([ser1],3)"
 
The sql looks like it should work.

--
Duane Hookom
MS Access MVP


Mark said:
Thanks Duane,

Antoher question, is it possible to use the right() in criteria when it is
a
field in the table. The "ser1" in the field I'm refering too, it is in
the
table.

vSql = "SELECT TASK_NUM, TOTE, DMS_WAVE, STORE_NUM, SER_CNT FROM
VIAWARE_DMSMSG_T WHERE """ & Right(vLkUp, 3) & """ = right([ser1],3)"


Duane Hookom said:
Use the Right() function. Check it out in Help.
Click to expand...
Click to expand...
 
Back
Top