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

 

[KenSheridan via AccessMonster.com]

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]

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

--



.

 

[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

--



.

 

[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
--



.

.

 

[KenSheridan via AccessMonster.com]

Strange. You don't need to save an update query in fact; you can run it
without doing so. Sure you didn't just open it as a datasheet? In any event
you seem to have achieved what you wanted.

Ken Sheridan
Stafford, England

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.

Let me ask the question just to clarify.

[quoted text clipped - 39 lines]

.