I have 2 tables:<BR>One is tblLocation with ID and location as fields, the other is tblFacility which has a field called locationID (relates to table 1)<BR>I need to query and get the following results:<BR>A complete list of all the locations from tblLocation AS WELL AS a count showing the number of records in tblFacility with a particular locationID.<BR><BR>The results should look like:<BR>Location 1 (4 records in db)<BR>Location 2 (1 record in db)<BR>Location 3 (0 records in db)<BR>etc<BR><BR>Help??<BR><BR>Thanks in advance,<BR>Sue