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?