Modifing Cells- Increasing numbers in a table

's Computer Specifications

Does anyone know how to quickly modify a bunch of cells? I have many mdbs with tables of numbers (ie 236, 273, 456 ...). I would like to: add 300 to all the numbers in column D, add 450 to all the numbers in column E, add 650 to all the numbers in column F and so on.... Are there formulas in Access to automate this task or is my only option to manual edit all the cells?

Thanks in advance

's Computer Specifications

Answered elsewhere

's Computer Specifications

Yes, me too! Yours was in microsoft.public.access, Allen.

--
Steve Schapel, Microsoft Access MVP

Allen Browne wrote:
> Answered elsewhere
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Beginner's] Increasing numbers in a table	pnumminen	Microsoft Excel Programming	4	9th Mar 2009 07:48 AM
Modifing Cells- Increasing numbers in a table	=?Utf-8?B?SmlmZnk=?=	Microsoft Access External Data	1	22nd May 2004 10:17 AM
Modifing Cells- Increasing numbers in a table	=?Utf-8?B?SmlmZnk=?=	Microsoft Access Forms	2	22nd May 2004 08:49 AM
Modifing Cells- Increasing numbers in a table	=?Utf-8?B?SmlmZnk=?=	Microsoft Access	1	22nd May 2004 08:08 AM
Modifing Cells- Increasing numbers in a table	=?Utf-8?B?SmlmZnk=?=	Microsoft Access Macros	1	22nd May 2004 06:33 AM