process records in a table

's Computer Specifications

Hi
I have a database with a table that has about 50 fields and 100 records.

I need to read each record in a table
look at one field and set variables depending on what is in the field
After reading all records, save those variables to a new table
Then repeat all of that for each of the fields.

Anyone know of a sample database or code I could look to get an idea on how
to do that?

Thanks,

's Computer Specifications

"apna" <(E-Mail Removed)> wrote in news:eLYdLGTSGHA.5780
@TK2MSFTNGP10.phx.gbl:

> After reading all records, save those variables to a new table
> Then repeat all of that for each of the fields.

Use a query?

Tim F

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete records from table 1 which match records from table 2	Matilda	Microsoft Access	7	27th Mar 2009 12:25 AM
Show only records in table A without matching records in table B	=?Utf-8?B?UGF1bG8=?=	Microsoft Access Queries	1	15th Mar 2007 06:34 PM
HELP!!!! Upload table records deletes existing records instead of appending.	rbagley@kodersolutions.com	Microsoft Dot NET Compact Framework	0	2nd Feb 2007 03:16 AM
Copy Records from Access Database table(more than 5 lakh records in this table) to Excel Sheet	divya	Microsoft Excel Programming	1	26th Oct 2006 01:12 PM
select all records on one table but limit records from 2nd table	=?Utf-8?B?am9hbg==?=	Microsoft Access Queries	8	3rd Nov 2004 02:38 AM