Changing Field Values in Multiple Fields

[MtBob]

Hello, brand new to Access and this forum. I searched and did not find this information. It's probably there but I don't know the right terms yet. I need to change the values in an entire column and increase each field by 10%. Is there a faster and easier way to change the values, rather than change them one by one, after doing the math in my head or on a calculator? I read about queries and macros but don't know enough yet. Is there step by step instructions for this out there somewhere? Thanks.

 

[MtBob]

I am using Access as a project connected to an SQL database on my host's server. I don't find the queries button on the left... Does this make a difference?

 

[mdemarte]

Look for Update Query. Also, give some thought to how you want to round off the result. There should be posts you can search for both of these topics.

 

[MtBob]

Thank you. I try to follow the instructions and there is no query design view button with the others in the objects list. If I create a DB on my computer the button is there, but not with the DB online. Could that be the difference?

 

[mdemarte]

Not sure if this has anything to do with the data being SQL, since I have not worked with a database that way. There are others who have. I suggest that you end this post here in the General folder and start a new one in the SQL folder. Just note that you started it in the wrong folder. Good luck!