Add records

[Elamranii]

Hi everyone,
I want to add # 50 to a field in a table.
table1 has one field called MemberContact.
the field MemberContact has 50 or blank like this:

MemberContact
50
blank
blank
blank
50
blank
blank
blank

I want to put 50 where there is a blank?
Thanks in advance
Ismail

 

[HarleyQuinn]

How about this:

UPDATE table1 SET MemeberContact = 50 WHERE MemberContact IS NULL

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[Elamranii]

Thank you very much for you help.