Show records even if they're not there! (Newbie)

gfcaim

Registered User.
Local time
Today, 15:40
Joined
May 26, 2004
Messages
20
I have one table that has area names, area1, area2,... (the 'one' side of a join) and another table that holds records related to a specific area (the multiple side of the join).
I want a report that lists the area as a heading, then all the records related to the area, then the next area, and so on. I know how to do this but if, say, there are no records for area2 then area2 does not show as the query omits it. I want all areas shown even if it means being followed by a blank space to signify no records for that area.
Probably embarrasingly simple but hey...
 
gf,

Get your query in Design Mode.

Right-Click the line joining the two tables and select join properties.

Select "All records from Left table and only those ..."

Anyway, that's where it is, experiment.

Wayne
 

Users who are viewing this thread

Back
Top Bottom