Amending figures in a Table in Access

  • Thread starter Thread starter Lucille
  • Start date Start date
L

Lucille

I am working on a big table in access and have been asked to update quite a
few figures. Do I have to do this manually or is there another way that I
can do this?

Many thanks.
 
Lucille,
There's no way we can answer that without any description of what your
fields are, and if there is any "logic" to the changes you want to make.

An example of a "logical" change might be...
For any Amount between 500 and 1000... add .02 to the Amount.
(That could be handled by an Update query...)

Please explain in more detail, and give examples.

--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
You have Update and Append queries for changing or adding data to your
tables. Update queries will change existing values. Append queries will add
more records. Check Access help to get you started on the one you need.
 
Back
Top