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
 

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

Converted from LINUX time ok, but having issues with the between date. 4
Type Mismatch in Expression 1
i am getting the message "Type Mismatch" 1
data mismatch 2
expression for time sheet returns type mismatch 1
Access 2003 6
Data mismatch error 2
Number to Number "Data Type Mismatch in Expression" in Join 1

Back
Top