Criteria to update a black cell

stafire_18

Board Regular
Joined
Dec 8, 2004
Messages
162
I'm having trouble trying to create a criteria for an update query to do the following.


I have a lot of blank cells that need to be updated to read "AAS Other" I tryed the following in the criteria
update to: "aas other"
criteria: ""
this does not do anything
& when I leave the criteria blank then it changes all the cells to read "AAS Other" I do not want this becuase there are other cells that have correct information in the same column.
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

pritcham

Board Regular
Joined
Oct 26, 2005
Messages
128
If the values are currently empty then use "Is Null" (without speach marks) for the criteria

Cheers
Martin
 

pritcham

Board Regular
Joined
Oct 26, 2005
Messages
128
Yes - in the criteria, if no data has been entered into a field then it holds a 'value' of Null (unless you've specified a default value) so if you put "Is Null" into the criteria bit then it will only update records where no value has been entered into that field.

Cheers
Martin
 

Watch MrExcel Video

Forum statistics

Threads
1,118,017
Messages
5,569,640
Members
412,284
Latest member
Daibear
Top