Compile error on Left function

[MsTrixie]

I have a few Left and Mid functions in my database that seemed to work yesterday but now they don't they look just fine to me but I keep getting Compile error. in query expression.

I am trying to concatenate the current first two letters of the group with the T so the records will change with an update query.
ex: CAP updates to CAT

Here it is....

Left([Sales Order Summary Data]![GROUP],2) & "T"

 

[Sohaila Taravati]

Refer to this posting it might help you!
http://support.microsoft.com/defaul...b;EN-US;q115915

 

[MsTrixie]

That page is no longer available

 

[Sohaila Taravati]

Then refer to this one!
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=34424

 

[MsTrixie]

There were no missing references. I ran a debug/compile and it told me that something was wrong with a module that I had created to test something. Not sure how it was linked but when I deleted the module it fixed everything.

thanks all