process records in a table

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,

"apna" <apna@etaleem.com> 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