Question Using Substring

[Okestra007]

Hello,

I have a field with string that I will like to trim the last two letters. The problem for me is that the total characters length will almost always be different. Please help me with removing the last 2 digits of whatever is entered.

Example: User entered

1. ABC123445A
2. THT676746
3. HGS87763392
4. GTD8821234000

Captured Data Should be;

1. ABC12344
2. THT6767
3. HGS877633
4. GTD88212340

Thanks

 

[spikepl]

Check out the string functions http://www.techonthenet.com/access/functions/

All you need is there.

 

[Galaxiom]

Left([string], Len([string])-2)

 

[Okestra007]

Thanks guys