Query and SQL

[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 think that could work, but don't know enough yet. Is there step by step instructions for this out there somewhere?
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?
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?
Is this a query question or an SQL question? Thanks.

 

[fuzzygeek]

SQL Server Question

This question would be better posted on the SQL Server area under Apps and Windows on this forum. You would have to accomplish it through the SQL Server area. It's relatively easy, but if you are inexperienced, you could destroy a lot of data. ADP is different from MDB. VBA doesn't work on the SQL Server Side.
That's not to say that you couldn't do it through VBA, but it would be simplier on the SQL Server side.

 

[pdx_man]

You could do this on the SQL Server, true, but you can also do it in an Access query if you can create another DB where you have the ability to create queries AND can link to the same datasource. You need to do an update query, in either SQL or Access. It will look something like this:

UPDATE YourTable SET YourTable.YourField = [YourField]*1.1