How to auto-fill field in Access 2010 Table

I have a table with about 1750 records, there is a field that is currently empty that I would like to populate with a name of a group called Sunshine.  Do not want this to populate going forward, just want to be able to have it filled in now.  Do not want to have to go to each record and put it in.  Any and all assistance, input would be greatly appreciated.
FreddyBassAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
Create an update query to populate the value.  With no criteria, it will update all records.  If you want to update only some records, add criteria to select the records you want to update.

Here's a sample that joins two tables and sets the careplan in one table to the value found in the second but only where the careplan is empty:

UPDATE TEMP_PAfromPortal INNER JOIN tblCarePlans ON TEMP_PAfromPortal.CPID = tblCarePlans.CPID SET tblCarePlans.PortalCarePlan = [TEMP_PAfromPortal].[CarePlan]
WHERE (((tblCarePlans.PortalCarePlan) Is Null));

Open in new window

0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
1. go to queries and choose new.

2. select the table you want to update.

3. change the query type to update.  When you do, you'll see a line in the grid appear called "Update to"

4. Pull down from the table into the grid the field you want to update

5. Fill in "Sunshine" on the "Update to" line under this column.

6. Execute/run the query.   it should tell you you have 1750 records to update.   If there are more records than just those, pull down additional fields and place criteria on them to get the records you want.   Just leave the "Update to" line blank for these.

 Note that you may want to leave it as a select query until you get all the records that you want, then switch to an update type.

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
FreddyBassAuthor Commented:
Hello Jim,

Thank you for your input and the way that you spelled out how to achieve solution was much appreciated.

Fred
0
Karthik ShanmugamCommented:
Hi Jim,

The information provided here on how to fill series in Access was very useful. I was working one important data for which I had to use this option. I must say it saved a whole lot of time. Thank You so much
0
Karthik ShanmugamCommented:
Hi Jim,

 The information provided here on how to fill series in Access was very useful. I was working one important data for which I had to use this option. I must say it saved a whole lot of time. Thank You so much
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.