[AccessD] internal recordset field names

Suppose two tables contain the same field name and you base a recordset on
those two tables and include both fields -- how does the recordset name (or
identify) the two fields? I know I can use As to alias them both, but how
would I refer to these fields within the recordset if I didn't?

Susan H.