If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Amending figures in a Table in Access
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. |
#2
|
|||
|
|||
Amending figures in a Table in Access
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." "Lucille" wrote in message ... 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. |
#3
|
|||
|
|||
Amending figures in a Table in Access
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. -- Milton Purdy ACCESS State of Arkansas "Lucille" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|