Related tables - i want results even with no data

[RobinL]

I have got two tables - one of institutions, and one of contacts

I am trying to make a query where the only stipulation is that there is a postcode and an institution name. (Im just using 'Is Not Null' for that.

The problem is that if there are no details for a certain institution in the contacts table, the institution is not displayed in the query.

How do i design the query so that it returns a list of all institutions regardless of whether they have contacts, but if they do, return one record for each contact?

Thanks a lot,

Robin

 

[raskew]

When joining the two tables in the query, use a Left Join (all the records from tblInstitutions and only those from tblContacts where the joined fields are equal.)

 

[RobinL]

thanks a lot, its working now