multiply tables in a query

M

marcia

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!!!
 
R

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.
 
J

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 []
 
Top