Truncation Problem: WOprefix: (Left([W#O#NUMBER],6))

[EhWot]

Hi, can if anybody can help with this I'd really appreciate it as it's bugging the heck out of me!

The above criteria worked fine until recently, however now it just gives ERROR! for each record. The dB is Access 97 and hasn't been changed significantly. I've been doing a lot of work in VB recently but can't think that that would cause problems with this.

Any ideas? Anybody?

HELP!..

 

[MartinCurrie]

WOprefix: Left(cstr([W#O#NUMBER]),6)

 

[EhWot]

Hey Martin,

Thanks for responding so quickly much appreciated.

Unfortunately as that didn't work either I think I have fundamental problems with the dB so will try copying the structure to a fresh instance and see if that works. Can't think of anything else to try.

Thanks again for your help.