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!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update query

Status
Not open for further replies.
ojosVerdes

ojosVerdes

Technical User
Oct 10, 2002
50
US
I have a table [tMembers] that in the NewCollector field it has either null[blank] or 1.

What I want to do is run an update querry to change all the blanks to No and the 1's to yes.

how do I do this?

Thanks in advance
 
Sort by date Sort by votes
Update tMembers set NewCollector = 'No' where Len(NewCollector)=0
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
857
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
764
dhookom
dhookom
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
678
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
633
TrekBiker
TrekBiker
applestoapples
  • Locked
  • Question
Make Table Query sort not working 1
Replies
2
Views
372
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top