Anyone know what is wrong here, Mid (TimeNow, 11, 5) as TimNOW

[johnseito]

I seem to be using the Mid function correctly because I have used it the way I am using it in the past which has worked, however I am getting an
error message this time and I don't know why.

Error message is

undefined function "MID" in expression

.
Could it be some setting I have in access that doesn't have some properties check off to use access's build in function?

Even if I correct Mid (TimeNow, 11, 5) to Mid (now (), 11, 5)
The same error occurs.

SELECT now ()  as TimeNow, len(now()) as Length_ofTime, Mid (TimeNow, 11, 5) as TimNOW

[pbaldy]

I'd start with references:

http://www.accessmvp.com/djsteele/ac...nceerrors.html

[johnseito]

Ok, thanks buddy. I see what happen.

[June7]

So is this solved?

[johnseito]

Yup, apparently access 2010, my version was looking for something in access 2007 and can't find it so that was the error and so I have to un-check the setting where is say Missing something from access 2007.