coding

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

Guest

Hi,

I have create a table records that ave anique id number such as 7.5-6-ND or
7.5-6-D

Now i need to refer to this number but only the characters after the last
"-" ie ND or D etc... Can we program the databse to return this characters
only.

Thanks for any ideas. I looked at various copying codes but none go to the
subform.
 
Hm hngo.

hngo said:
I have create a table records that ave anique id number such as
7.5-6-ND or > 7.5-6-D

Now i need to refer to this number but only the characters after the
last "-" ie ND or D etc...
Can we program the databse to return this characters only.
Click to expand...

Yes you can. Depending on your Access version, this might work:
Mid$([ID], 1+InStrRev([ID],"-"))
Use this calculated expression in a query.
 
Back
Top