I have two tables that are linked by a one to many relationship. I want a query to run that lists all the records in the parent table followed by whether or not they have a related record in the child table (and possibly even how many records exist). Does anyone know how to do this?

- put both tables in the query designer;
- right-click the join-line and select 'join properties';
- select the button that will give you all rows from the desired table;
- add desired fields from the table with all the rows;
- add this to an EMPTY field, in the top row:
Has Child Records: IIf(IsNull([ID-Field of Child Table]),"No","Yes")
- add ice and serve immediately.

Addition:
What no straw....

thnx for the help