Changing a group of prices

I

image1

Is there a way to change, in table view, a section of data in a column by a
%? I need to change about 5m prices at once and was curious is there was an
easy way to do this
 
J

John Spencer MVP

You need to use an update query to do this.
STEP 1: BACKUP your data before attempting the following.
STEP 2: BACKUP your data before attempting the following.

Without a backup you cannot restore the data if this does not work the way you
expect.

UPDATE SomeTable
SET SomeColumn=[SomeColumn]*(1+PercentChange)

In the query design view
-- Add your table
-- Add the field you want to change
-- Select Query: Update Query from the menu
-- in the Update To "cell" under the field you want to permanently change
enter something like
[SomeColumn]*(1+PercentChange)
-- Select Query: Run from the menu

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

KARL DEWEY

Is there a way to change, in table view, a section of data in a column by a
%?
By 'a section of data' I assume you mean some of the records. Therefore
you have to include criteria for those records or exclude those not to be
changed.

John Spencer MVP said:
You need to use an update query to do this.
STEP 1: BACKUP your data before attempting the following.
STEP 2: BACKUP your data before attempting the following.

Without a backup you cannot restore the data if this does not work the way you
expect.

UPDATE SomeTable
SET SomeColumn=[SomeColumn]*(1+PercentChange)

In the query design view
-- Add your table
-- Add the field you want to change
-- Select Query: Update Query from the menu
-- in the Update To "cell" under the field you want to permanently change
enter something like
[SomeColumn]*(1+PercentChange)
-- Select Query: Run from the menu

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Is there a way to change, in table view, a section of data in a column by a
%? I need to change about 5m prices at once and was curious is there was an
easy way to do this
Click to expand...
Click to expand...
 
Top