multiply tables in a query

[Guest]

if I have multiply tables in a query that have the same field names....how to
I specify which table to use.

I know you put the table name first then the field name but I'm not doing
the correct puncutation????

Thanks My brain isn't working today!!!

 

[Rick B]

In the query design grid there is a drop-down for "Field:" and right below
it is a dropdown for "Table:". Just pick the table from there.

 

[John Spencer]

In Access the syntax is
[Tablename].[Fieldname]

Although in most case, if the object names don't have spaces or special
characters (punctuation marks, etc) then you can avoid the []