Create an Update Query in Access

Use an update query to change the value of a numeric field in multiple records.

[bokenrosie]

Thanks for speaking during your demo. Too many others out there where they do not speak and we are left to guess what they are doing. Update query with values from another table. Easy peasy after watching your video.

[robinfoster]

You just helped me again. I didn't realize I needed to change the update query back to a select query before running it again and kept coming up with the same results. You helped me!

[DeborahGravenor]

Great video.  Very clear and logical.  Helped me to understand this type of query much better than by following my textbook.

[renc]

Great explanation! Thanks for making this.

[Jojosmith]

thanks for the valuable tutorial. Subscribed and thumb up

[quachuonglilac]

amazing video. It helps me a lot in my Access project

[VFXLtd]

When i type the command " [Price}*0.025" it replaces the current prices not increase it by 2.5%.. Do you know the command to increase it by 2.5%?

[chetangowree]

when i will update the query, will it change the information in all the table having the specific field?

[rosemariepaul]

I have one question...Im trying to update a table that has several fields that are to be updated.
Here is the question and i cant seem to understand what it is im doing incorrectly.
Create update query that will update any patient that had an X-ray or a Blood Test that will seen Dr. Holle.
this is a review question for a test im doing.  Nothing im doing (following my notes and youtube). 
Does anyone have a suggestion...

[gabriellesabler]

So how would you do this for a Music database?

[gitishasapkota]

I'm watching this video in 2020☺️☺️🌺

[albertofresneda]

Man Like Ralphie ! i rate that i rate that