find out if a recordset contians a field

R

Rod

I have a dao.recordset which is made from a crosstab sql.
I want to know if a particular field name is one of the recordset's fields.
Is there a neat way of doing this without using onerror?

many thanks
 
D

David C. Holley

Without trapping an error, which would be the quickest (realatively) and
shortest method, you'd have to cycle through the fields collection of
the recordset looking for the name of the field.
 
Top