The collection contains all the field objects of a Recordset or Record object. The Fields collection has only two properties you'll use: the Count property, which returns the number of Field objects in the collection; and the Item property, which returns a specific field in the collection.
D.7.1. Methods of the Fields Collection
Methods for the Fields collection are listed in the following table.
Method
Description
Append
Creates and adds a field object to the Fields collection
Update
Finalizes any additions or deletions to the Fields collection