db tools update data.vi - insert null fields MS Access

[robertgalusha]

I've been trying to insert a null string into my MS Access table by using Db Tools Update.vi

What I am getting is 0.0000 & what I really need is the field to be blank.  I have a program that uses any values in this field for calculations and if a zero is present during the multiplication, the return value will be of course zero.  

Can DB tools update data.vi be used to return a null (empty) value in the field or should this be approached differently?

thanks

[jcarmody]

What are you sending the Update vi?  I don't know how you'd do that with the Update vi.  Try using the Execute Query vi with something like "UPDATE <your table> SET <your field> = NULL WHERE <your criteria>".