need to run update to fill empty cells with out overwriting

[wheels27]

I Need to run an update query to fill in a dollar value, it is set to text but then it sees a cell that has a date or dollar value it won't cange or update it, essently it only fills cells that are emptyand does not over write the cells with data. I have had the problem with over writing data.

sample:

152.60 152.60 152.60 01/05/02 Returned
152.60 152.60 152.60 152.60 152.60 03/12/02 Returned

if i tell it to fill col 4 it will over write my date as you can see. how do i avoid this.

 

[SgtJarrow]

Tell it to fill column 4 if column 4 is Null.....as such

In the update query, in the Update to Field put whatever you want the field to be updated to....

in the criteria field, put

Is Null

This will search for any column 4 field that is null and update....but will not update if data exists If we knew what it was we were doing, it would not be called research, would it? - Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com