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...
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...