data type mismatch

O

opeyemi1

Hello:

I am also having a data type mismatch error. Both data field ar
date/time with medium date format. In my query, I want access t
replace all blank spaces in a column with values in another column.
don't know why I am getting the error, please help. Find the SQ
below:

WHERE ((([Invoice StateJan 14-April30].[Transaction in Stat
Since])=IIf([Invoice StateJan 14-April30]![Transaction in Stat
Since]=" ",[Invoice StateJan 14-April30]![Logged Date],[Invoic
StateJan 14-April30]![Transaction in State Since])));


Thanks


opeyem
 

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

problem with iff statement and is null 0
iff statement in access query is making my data shrink 0
Data type mismatch error --> text to date 1
Data type mismatch 6
type mismatch error in macro in excel 0
Data mismatch error 2
Noob question - Data Type Mismatch 5
type mismatch 2

Top