Sorry for the awkward title. Let me try to articulate this differently. I want to run a query for records from two tables: subpoenas and receivables. Some of the records on the subpoenas table have a corresponding record (matching key #) on receivables table. Thus, for those records, I want to include the respective invoice numbers on the query report. However, many of the records in subpoenas do not have corresponding records on receivables. I want to include those records in the query as well. However, the minute I bring the receivables table on the query, the data is immediately limited to records present on both tables. Thus, records on the subpoenas table that do not have a corresponding record on the receivables table are omitted from the query. Is there a way around this? Can I design the query to include the records from the subpoenas table that do not have corresponding records in the invoice table?