query syntax / layout

[susan]

Hi,

How to write a query that display fields which excist in tabke1 as well as
in table2?

Table1 with fields:
- age
- name

Table2 with fields:
- name
- street
- city


Query must show all records of Table1 where "name" is the same as "name" in
Table2.

Thanks,

Susan

 

[John Spencer]

--Add both tables to the query
--Drag from Name in Table 1 to Name in Table 2 (this creates a join between
the two tables - which is represented by a line)
--Select the fields you want to see from the two tables by double clicking on
the field name.

If for some reason, you want to see all the records in one table EVEN IF there
is no matching record in the other table, then double-click on the join line
and select option 2 or 3 in the dialog box - show ALL from x and only matching
from Y.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County