forms & tables

I

idcreek

How can I keep all the records from one table, when I do a query between two
tables.
 
R

Rick Brandt

idcreek said:
How can I keep all the records from one table, when I do a query
between two tables.

Double-click the join line in the design view of the query. You will get
three choices which are self-explanatory.
 
Top