insert into - if field is empty....

[mjonson]

hi,
how do i make a query that inserts a value into a field as long as the field is empty

 

[PHV]

UPDATE yourTable SET yourField = 'yourTextValue'
WHERE Nz(yourField, "") & "" = ""

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mjonson]

thanks phv