Error msg - please help!! "Compile error. in query expression .."

W

Will_Harris_ZA

Hi there

Please help!!!

I have entered this innocuous expression in a query in my database:

Days lapsed: Now()-[Last contact]

and am picking up this error message:

Compile error. in query expression 'Now()-[Last contact]'

And I can't understand why ([Last contact] is a unique field in the query).
Is my database corrupted?

Any help will be greatly appreciated.

Thank you
Will
 
D

Dale Fye

What is the data type of the [Last contact] field? Can it be NULL? Do you
have any NULL values?

What happens if you use:

Days lapsed: IIF(ISNULL([Last contact]), NULL, Now()-[Last contact])

Dale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compile Error. in table-level validation expression in append query 0
Compile error in table level validation expression in ms access office 2019 0
"Compile error in table level validation expression " after format 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Compile error in Query Expression 2
help in compile error 1
Dlookup Expression Error 2
Error in IIf Expression 5

Top