Problem with tables (beginner)

[alouest]

Hello,
My database is based on a table nammed Places wich contains FIPS code ID_places ZIP and name of places. I have 355 records in this table.


Attached to that by ID_places, i have a table which display the business and kind of business in those places. The problem is that i just have 250 different places in this table. I would like that while I do my querry, access display the 355 places and 0 as values for the cities which doesnt have information in the business table. Is that possible? Do I have to fill the 105 missing places with 0 in my business table?
Thanks verry much

[pbaldy]

With your query in design view, edit the join between the two tables by right-clicking on the join line, and select the appropriate join.

[alouest]

Thanks for the answer but I don't get it. Well i have this problem for several tables so let's take another example.
There are 355 Places in the Places table, which all have a FIPS.
There is an airport in 328 places so in airport table I have 328 Fips, ARP_within_miles is if there is an airport within 5 miles the place. But I just put the 1 (yes value).
So what I want as result it's a table with the 355 places and beside that the 1 form my airport table and 0 for the city who doesnt have.
Is it possible or do i need to put the 355 places in the airport database and fill with 0 for those who dont have any airport

[pbaldy]

Right-click on that line between the FIPS fields to edit the join. You'll see a choice like "Include all records from Places...".

[alouest]

Ahh that's what you meant, sorry! Thank you verry much you make my day

[pbaldy]

Happy to help!