I am building a db with Access 2000. I wnated a co-worker to help me trouble shoot and critique the db.
I copied and pasted the db from my C: to his C:. He is getting an error...
"Function is not available in expressions in query expression 'IIF(([DEnd] is null... and so on.
It looks like it does not like the IIF statement. It works fine on my computer. We are both using Access 2000.
Do you know why it doesn't like the expression??
Any suggestions on how to fix this??
I copied and pasted the db from my C: to his C:. He is getting an error...
"Function is not available in expressions in query expression 'IIF(([DEnd] is null... and so on.
It looks like it does not like the IIF statement. It works fine on my computer. We are both using Access 2000.
Do you know why it doesn't like the expression??
Any suggestions on how to fix this??