Compile Error?

[simon4amiee]

Age: DateDiff("yyyy",[DOB],Date())+Int(Format(Date(),"mmdd")<Format([DOB],"mmdd"))

This has worked for the last year, and today I tried running the query and got a compile error, very odd!

 

[plog]

Works for me. Something else must be the issue. Make a back up of the query then rip one field out of it at a time and see if it runs. When it doesn't that last field is the culprit.

What exactly does the error say?

 

[R. Hicks]

This is usually an indication that there is a Missing or Broken Library Reference in the application ...
I would check the references to confirm this ...

R.