Error message

[Prince]

I made report from a query and I used mid function on that query
fisrst It was working probably but now when I diplay that report it diplays mesage
saying:
undefined function " mid" in expression
anyone have any idea how to fix this problem?

 

[dcx693]

Can you post the SQL of the query? Or at least the part with the Mid() function? The way you posted the error message, it makes it look like there's a space before the Mid() function.

 

[WayneRyan]

Prince,

It sounds as though you are missing a reference. Get some
of your code in Design View and select Tools --> References.
One of them probably says "Missing".

Compare your libraries to the ones on a functional machine or
search here on this forum for "references".

Wayne