right() question

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

Guest

Hello all,

Thanks too
Duane Hookom
MS Access MVP

For leading me to right(), now another 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)"
 
Back
Top