Compile error on Left function (1 Viewer)

M

MsTrixie

Guest
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"
 
M

MsTrixie

Guest
That page is no longer available
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 18:23
Joined
Feb 19, 2002
Messages
42,976
The problem is a missing references issue. You probably installed some software that updated some .dll that Access shares. Search for missing references for lots of posts on the topic and suggested fixes.
 
M

MsTrixie

Guest
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
 

Users who are viewing this thread

Top Bottom