type mismatch

  • Thread starter Thread starter alyssa
  • Start date Start date
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
 
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
 
Back
Top