Autofill

[tomhorn80]

Can I fill all cells in a column that dont contain any data with the same value?

I have a table with about 1000 records, I have a column called "brand", half of the records contain some data but the other half dont and I really the ones that dont to contain the text "none".

Any Ideas?

Thomas

 

[epicmove]

autofill

Would have thought you could do an update query.
Stick the field in that you want to update and set the criteria for all records where the value is ""

Still new at this so someone else may have a better solution

 

[tomhorn80]

Thanks

You may be new but your good, worked a treat.

Cheers

Thomas