Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replacing data in a field 1

Status
Not open for further replies.

kkarren

Technical User
Joined
Mar 30, 2000
Messages
33
Location
US
I want to change the value of a field from say 0 to 1 in all records. What syntax can Use to make this universal change. This would be like doing a find and replace all in the table. I want to do this in a VBA setting. Can anyone help me? Thanks for your time. [sig][/sig]
 
update tablename set fieldname=value where fieldname <> value
[sig]<p>nick bulka<br><a href=mailto: > </a><br><a href= </a><br>[/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top