How to Create Update Queries in Microsoft Access - Update From Another Table with Join, Update Query

Learn how to create Update Queries. You will learn how to fix the values in one table, and I will show you how to update values based on records in a different table.

Bruce in Jacksonville FL (a Gold Member) asks: My customer table is all a mess. I didn't properly design it from the beginning, and now I've got all kinds of crazy data in it that I need to fix. For example, in the State field people have typed: New York, NY, N.Y., and so on. How can I fix this quickly and easily?

LINKS:

BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to update product pricing in your database based on information given to you by your vendor. You will see how to review products with different prices, see discontinued items, and add new items with an append query.

MEMBERS ONLY VIDEO:

BECOME A MEMBER:

ADDITIONAL RESOURCES:

OTHER ARTICLES:

KEYWORDS:
update query access
ms access update query
ms access update query from another table
access update query with join
access update query multiple criteria
access update query add to existing value
access update field in table

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[GeorgeAsam]

Your video helped me preserved the integrity of a 40 years data production history. Thanks a million.

[Jojosmith]

This is what I need to update the files status. Thanks a lot Richard. Thumbs up from start

[ivansanjuan]

I owe you so much. I started using Access a month ago and I have been learning from you, while making a database for an internship.

[marcdathird]

I always appreciate how easy you make your videos to follow and how informative it is too. 👍

[JLvatron]

I knew how to do this 2 years ago, but was blanking now. Thank you so much!!

[hfarhaan]

Thank You for sharing, very informative

[gonefishing]

Again thank you thank you and thank you. I had a database that partially needed to be rebuilt... my bad. And my update queries had to be redone and I forgot how to do them.

[hggryrdchgc]

Why does mine say "field cannot be updated"?

[kxhgkcm]

Can you automate an update query to run at a certain time? Once a day or once every couple days?

[ssdusd]

Nice!
What about if I want to select only Filtered records? for example if I filter a form I want to selected only those records how can we do it plz

[creativecurbappealllc]

Hey sir, how do you use an "Update Query" to Change Price by using a Form and Text Boxes to Set Prices to?

[hkycsiw]

Please mr ritchard I want to study the level 3 of beginner access

[arpatil]

Where can I find an extended cut? I'm a member.

[archanaaa]

How to use update query if we want increase any number by 10 percent?

[robertmceuen]

I joined but all it did was charge my credit card. No opportunity to create a logon so I could access beginners course you advertised.

[markdale]

Tried this a number of times but can't get it to work, I run it and nothing happens??

[Martosway]

I Had to use query wizard just to do this . for some reason i couldnt click and drop

[rabidfollower]

The user asked for a "quick and easy" way, so maybe he could just do a Find & Replace on the datasheet table. Or he could sort the table by state so all the N's are together, then manually correct them or use Find & Replace.

[azrienaroslen]

Can we make report based on update query ?

[purnendupal]

Respected, can you help me for the below:
I want to update a table field with the sum() of group by from another table having same Item.
Actually, I want to update a table called "Netstock" having fields: (Item, Category, Qty) . And another table called "Inward" having fields: (Bill_No, Bill_Date, Item, Category, Qty, Price, Amount) . Now, I want to Update the "Qty" field of "Netstock" with Sum(Inward.Qty) Group By Inward.Item, Inward.Category where Inward.Item =Netstock.Item and

I'm not able to find out any solution for the same.
Please help me🙏🙏