Update Table with query

[Mike]

I have a simply table (Rate Table) with two fields, Rate# and Rate (dollars).
I need to write as simply query within Query Design that will multiply 10%
times the Rate and update the rate with the new amount.

Any help appreciated.

Mike

 

[Mike]

Thanks Ken, I tried that and that rate did not change. I selected update and
entered [Rate] * 1.1, hit run and the update did not occur, I am using access
2007. Any suggestions?

Mike

Mike:

UPDATE [Rate Table]
SET Rate = Rate * 1.1;

In query design view add the rate column to the grid, select 'Update Query'
from the Query menu (or whatever the 2007 equivalent is if you are using that)
. In the 'update to' row of the column enter:

[Rate] * 1.1

Ken Sheridan
Stafford, England

I have a simply table (Rate Table) with two fields, Rate# and Rate (dollars).
I need to write as simply query within Query Design that will multiply 10%
times the Rate and update the rate with the new amount.

Any help appreciated.

Mike

--
Message posted via AccessMonster.com


.

 

[John Spencer]

Let me ask the question just to clarify.

You used the query design view.
You selected query: Update from the menu
You selected the [Rate] field into the list of fields
You entered [Rate] * 1.1 in the UPDATE To cell under the [Rate]field
You selected Query: Run from the menu

Did you do all those steps and the update did not occur?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Thanks Ken, I tried that and that rate did not change. I selected update and
entered [Rate] * 1.1, hit run and the update did not occur, I am using access
2007. Any suggestions?

Mike

Mike:

UPDATE [Rate Table]
SET Rate = Rate * 1.1;

In query design view add the rate column to the grid, select 'Update Query'
from the Query menu (or whatever the 2007 equivalent is if you are using that)
. In the 'update to' row of the column enter:

[Rate] * 1.1

Ken Sheridan
Stafford, England

I have a simply table (Rate Table) with two fields, Rate# and Rate (dollars).
I need to write as simply query within Query Design that will multiply 10%
times the Rate and update the rate with the new amount.

Any help appreciated.

Mike

--
Message posted via AccessMonster.com


.

 

[Mike]

Thanks replying.

Yes I did those steps but what I forgot to do is after building the query I
forgot to save it and close it before running it. Once I saved it, closed it
and then went back into it, I was prompted with the screen you are about to
change data do you want to proceed. Then it worked.

Before I just hit the run botton after building the query and it would not
work.

Thanks for your help.
--
Mike

Let me ask the question just to clarify.

You used the query design view.
You selected query: Update from the menu
You selected the [Rate] field into the list of fields
You entered [Rate] * 1.1 in the UPDATE To cell under the [Rate]field
You selected Query: Run from the menu

Did you do all those steps and the update did not occur?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Thanks Ken, I tried that and that rate did not change. I selected update and
entered [Rate] * 1.1, hit run and the update did not occur, I am using access
2007. Any suggestions?

Mike

Mike:

UPDATE [Rate Table]
SET Rate = Rate * 1.1;

In query design view add the rate column to the grid, select 'Update Query'
from the Query menu (or whatever the 2007 equivalent is if you are using that)
. In the 'update to' row of the column enter:

[Rate] * 1.1

Ken Sheridan
Stafford, England

Mike wrote:
I have a simply table (Rate Table) with two fields, Rate# and Rate (dollars).
I need to write as simply query within Query Design that will multiply 10%
times the Rate and update the rate with the new amount.

Any help appreciated.

Mike
--
Message posted via AccessMonster.com


.

.