If you actually have a SQL query that returns multiple recordsets (which is completely possible), then you'll need
to use the ADODB.NextRecordset reference to get an object reference to the 2nd,3rd, etc recordsets in your query.

You can then access their fields through standard ADODB object variables.

HTH,
Ed

>I have a recordset based on an SQL query, it includes more than one table. How do I refer to this in code?
>
>In the past I have only used recordsets consiting of one table and so I have used the sytanx
>
>recordsetname!fieldname
>
>but there could be more than one field with the same name in the recordset that I am using now, but from different tables,
>
>I tried
>
>recordsetname!tablename.fieldname and
>recordsetname!tablename!fieldname
>
>but had no luck with either.
>
>Can someone help please?