Compile error from function in sql query - Was working before!

[TerraEarth]

The error: Compile error. in query expression 'MID(document,1,6)="XXXXXX'.



The query:

SELECT * FROM qry_a
WHERE 
MID(document,1,6) = "XXXXXX";

I'm completely lost. I was developing a program to generate PDFs with query values, after I had tested it several times one of my queries broke. I tried compacting and repairing but that did not fix anything either. This query was working just fine just an hour ago! Any idea?

[isladogs]

Is qry_a based on a table or another query. If the latter, look for fields like expr1 in the underlying queries which could occur due to your crash.

[TerraEarth]

qry_a is based on a series of inner joins between several tables. qry_a works just fine at the moment.

[isladogs]

Check there are no references marked as MISSING.
I just tested on another users database with a missing reference and got an undefine function error using Mid in a query.
Fixing that solved the issue.

If that doesn't solve it, try another Access function such as Left or Nz and see if those work.
If not I suggest running an Office repair

[TerraEarth]

Check there are no references marked as MISSING.
I just tested on another users database with a missing reference and got an undefine function error using Mid in a query.
Fixing that solved the issue.

If that doesn't solve it, try another Access function such as Left or Nz and see if those work.
If not I suggest running an Office repair

I tried all of the above, no luck. What I ended up doing is rewriting all of my queries so I could avoid using a function such as MID in the query completely, though i wish I could figure out what went wrong . It was working just fine so I'm not sure what could have happened - corruption mayhaps?

[isladogs]

Corruption is certainly possible.
See this link for my approach to such issues https://www.access-programmers.co.uk...7&postcount=12

[Micron]

document is a reserved word. If you must use it, surround with [ ]
Maybe not the issue, but can't hurt to test if it is.