coding

[hngo]

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.

 

[Wolfgang Kais]

Hm hngo.

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.

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