Don't know what to tell you; as a Calculated Field your syntax of
works just fine, for me! Made up a Table with fields APP_DATE and SHIP_DATE, created a Query with it, then pasted your code directly into a new Field in the Query Design View. The SQL Statement would be something like:
If you can save the file in v2007 or earlier format, Zip it up and attach it to a post, here, I'd be happy to look at it.
SELECT TableName.APP_DATE, TableName.SHIP_DATE, IIf([APP_DATE]<[SHIP_DATE],"YES","NO") AS Status
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007