type mismatch

A

alyssa

When I try to open a query that has been ran and used time
and time again, now it says "type mismatch in
expression". It says that on all of them in that
database. Why whould it do that? Has something been
changed on it? If you can help please do so!!

Thanks
 
T

Ted Allen

Hi Alyssa,

My guess is that you probably have null values in a field
that is used in a calculation. If so, you can use the Nz
() function inside the calculations to substitute a zero
or some other value for a null.

Hope that helps, post back if that wasn't it.

-Ted
 
Top