Skip to content

Returning All Table Records in a Query

How to make all table records appear in a query regardless of whether they have any linked Extras records.

Q:  Liz has a query that returns records from a Registration table and an Extras table.  She needs the recordset to include all the records in the Registration table regardless of whether they have any linked Extras records, but she is only getting the Registration records that have Extras.

A:  Open the query in design view, double-click the link between the Registration and Extras, and select the option that gives you all the records in the Registration table, whether or not they have matching records in the Extras table.  The default link type only returns records when there is a match.

About this author