I need a shortcut--PLEASE HELP!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to add an increase of $2.50 to every amount in an Access database table all at once instead of changing every amount individually? I'm trying to update A FedEx shipping rate table. Any help would be greatly appreciated.
 
Kelly said:
Is there a way to add an increase of $2.50 to every amount in an Access
Click to expand...
database table all at once instead of changing every amount individually?
I'm trying to update A FedEx shipping rate table. Any help would be greatly
appreciated.

You need to use an Update query in SQL.
Presuming that by "add an increase of $2.50 to every amount in an Access
database table all at once" you mean that you have a column called (for
example) ShipRate in a table called Orders (again, for example), you want to
add $2.50 to the value in the ShipRate column for every row in the table,
just create a SQL query like:

UPDATE Orders (replace Orders with the name of your table)

SET ShipRate = ShipRate + 2.50



Note the absence of any WHERE clause to constrain the rows affected, thus
the Update will affect all rows.

The query above will add 2.50 to the current value for ShipRate in every row
in the Orders table.
 
Kelly,

Make a query in design view based on your table, and put the Amount
field into the query design grid. Make it into an Update Query (select
Update from the Query menu). In the Update To row of the Amount column
in the grid, put
[Amount]+2.5
(assumes Amount is the name of the field you are trying to increase)
Run the query (click the button on the toolbar with the red ! icon).
Voila!
 
Back
Top