Update Query Data Mismatch (1 Viewer)

[PeterCroxson]

Hi,

I am trying to set up an update query which will put a zero into fields (of type Double) where they are left blank after the data import.

I have set up an update query with the Criteria of "" and in the Update field, I just put 0 ... and when I try to run it, it tells me I have "Data Type Mistmatch in Criteria Expression" ... now, I am sure this is quite simple to fix, but I'm stuck ... any suggestions???

Thanks

 

[Lisa_Wilderspin]

Peter,

Have you tried this?
In the query design view go to the query menu and click on parameters.
You can then specify the data type for your parameter so it matches with the data type in the field properties of your table.
Hope this helps,

Lisa

 

[Rich]

Put Is Null in the criteria
HTH