Access 2003 pricing column

  • Thread starter General Mailbox
  • Start date
G

General Mailbox

Greetings.
I'm working for a new on-line retailer (small shop) and I'm asked to reduce
a large section by 10% in the OurPrice column. We use spreadsheets to
import the data initially. Is there an easy way to select these (over 3000)
rows and apply a math function? If not in Access, how about Excel? I am
told that as long as the ItemsID column, which is populated automatically by
Access, is shown on the spreadsheet, Access should not create duplicates
entries.
Anyone's help is greatly appreciated!
Rgds,
Kevin
 
A

Allen Browne

Use an Update query.

1. Create a query into this table.

2. Enter any criteria, if you only want some products changed.

3. Change it to an Update query (Update on Query menu.)
Access adds an update row to the grid.

4. Drag the OurPrice column into the grid.
In the Update under this field, enter:
0.9 * [OurPrice]

5. Run the query (Exclamation icon on toolbar.)

You might want to round the values.
At step 4, use an expression like this:
Round(0.9 * [OurPrice], 2)
 
Top