I have an mdb that has had a SQL query with a mid function in it for ages 
and it has worked.  Now I am suddenly getting an error telling me that the 
function cannot be included in the expression.  The SQL query also has an 
instr function in it and it works if I take out the mid function.

Anyone else had this problem?

Regards, Phillip

Phillip,

<< I have an mdb that has had a SQL query with a mid function in it for 
ages and it has worked.  Now I am suddenly getting an error telling me 
that the function cannot be included in the expression.  The SQL query 
also has an instr function in it and it works if I take out the mid 
function. >>

It sounds like one of your reference libraries quit on you.  Open any 
module or procedure and click TOOLS | REFERENCES and make sure all your 
necessary libraries are chosen.  I don't know which one is specifically 
for the MID() function.

Greg