Update Query Help

[hatstand]

I’m new to Access and new to the forum, Hi. I'm in the process of creating a database that uses an Update Query to populate one table to another. I've created a simple 3 field database to practice on. The fields are ID, Colour, Amount. My problem is updating only one figure without wiping the whole record. as I never know which field within each record might change. I have added all of the fileds to my Update Query. So if I only wanted to update record 1 to colour Black. It will replace the Amount with a blank. Am I making any sense? Any pointers would be much appreciated.

 

[Trevor G]

Welcome to the forum,

Take a look at this video on Update Queries on YouTube, it will help you.

http://www.youtube.com/watch?v=--PVVLIcbjE

 

[hatstand]

Thanks for the reply.

I can't access the video due to security software as I'm at work. But I will post the link home and have a look tonight. Just as a quick question. Am I on the right track by using the criteira or an IIf. My usual program is Excel so I keep thinking If statments.

 

[Trevor G]

You can set criteria so select the field, add the criteria to ID1 (If that is the number), then from the other field, in the update set to "Black"

The help file in Access for Update Queries is fairly useful. Press F1 and type in Update Query