147 fields named like this suggests that you would be better off with a different data model--perhaps one with up to 147 related records of one field each instead of 147 different fields in one record.
That said, the getfield function will allow you to indirectly reference a field.
GetField ( "YourTableOccurrenceName::Field" & $n )
Thank you for your help. Actually the 147 fields are imports from an Excel workbook. Within this workbook and the 147 fields which are answers to test questions, a lot of these fields are attributes to the questions so the actual data model has about 73 records with maximum 5 fields each. Which makes things a litlle more sound than 147 fields named field1,field2,field3..... Thanks again!