• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1067
  • Last Modified:

how to change multiple rows in a table

I am using access directly. No code is being used. When I have a table open, how do I change the field of multiple rows.  I can select multiple rows, but cannot find a way to update a field for all those rows.  Example: Fields hello, color, istrue  Question: How would I set multiple rows color field to say, 12345.

Also, a nagging question. What do experts get out of answering these questions? Can you redeem your points for cash or some other product?  Just recognition?  Thanks.
0
grknight
Asked:
grknight
1 Solution
 
grknightAuthor Commented:
Access version is XP
0
 
walterecookCommented:
All we get is the satisfaction of having helped people.  And it feels good.

Set up a query that pulls the records you want.
Then change that to an update query.
In the "Update to" section of it, put you new value.
It will change that field to your new value for all the records that apply.

Hope that helps
Walt
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now