Query based on two tables only returns records if they have info in the second table

[timesscript]

I am trying to create a query that will give mainly info from Table A, but I would like to include Table B so that other relevant info can be shown in the query. The tables are related.



However, not every record in Table A has something entered for the field which is related to Table B.

Here's my problem: Whether or not I set a criteria, or even list a field from Table B in the Query, records in table A that have no entry for the field that relates them to table B are not returned in the query.

So if I remove Table B from the query completely, those records do appear, but if I add it back in, whether or not I even list any fields from the table in the query at all, the records don't appear.

Thanks for any help!

[ItsMe]

Maybe you can adjust the properties of the JOIN.

In the Query Designer, there is a line that connects two tables/queries. This line represents the JOIN. If you double click it, you will see the properties window.

Maybe having all records from one table will produce the desired results. Because, right now it sounds like you have an INNER JOIN.

[timesscript]

Thanks ItsMe, that did fix it!

[ItsMe]

Glad to hear