Update a field

[maxmangion]

I have a table with about 5000 records. Now i decided to add a new field to this table and call it "Rating". Eventually this field is going to be a combo box, which get its values from a lookup table called tblRating.

At the moment in the table with 5000 records, i have this field blank for all the records. Now i would like to assign the "Not Rated" value in each of the 5000 record rather than leave it blank. How do i go about doing this ?

I've tried to do it with an update query by putting the "is null" in the criteria and 1 (the id of the value 'Not Rated') in the update to ... however, to no avail.

Any suggestions please ?

Thank You

 

[wazz]

seems like that should work. you might have to add the field twice, once for 'update to' and once with criteria. (or leave out the criteria altogether if you want to update all the rows (?)).

 

[maxmangion]

actually, i have tried leaving the criteria empty, but still to no avail.

 

[maxmangion]

Problem sorted, as i thought that the View option would give me a preview of the result before the actual update happens.

 

[wazz]

ahhh. yeah, so did i.

 

[misscrf]

not that this is an issue any more, but you can also do a find a replace from the table. Just find null and replace all with your value. If replacing a field that is a look up, just make sure to replace the id not the text...
hth