query won't display records with no related records

[James Brazill]

I have two tables - 'Experts' and 'Species' that are linked via an expertspecies link table. Each expert can have multiple experts associated with it and vica versa (including none). I want a simple query that lists all species with all associated experts for each species, but when I do this, it only lists species with at least one associated expert. How do I make the query show all species - even those with no associated experts?

Thanks!

[SteveH2508]

You need to play around with the query joins. You will see an option saying something like Show All Records for species... and the join will change to having an arrow on it. The SQL will change to show a LEFT JOIN or RIGHT JOIN as opposed to an INNER JOIN.