Update query to change field data to blank

[xtrareal22]

hello.I want to update the data in the field to blank using an update query.I tried to update to null for the field but it does not want to work,.Help?

[lfpm062010]

What error did you get?

Is the field (column) Nullable? That mean does it allow null value for that field (column).

Can you post your SQL? (Right click on the query tab and select "SQL View")

Blank ("") and Null are different. To find blank use criteria (""). To find Null use criteria ("Is Null", without quotes)

[xtrareal22]

never mind it works.thanks and sorry for the inconvenience.

[Dal Jeanis]

please mark the thread solved. top of page, under "thread tools"