Print all group headers even when no data in detail

[DoghouseRiley]

I'm trying to produce a report with hirerarchically numbered headings in it like this:

1  Chapter One
1.1 Background
  This is an example para.
1.2 Introduction
  Another example para
  Yet another sentence.
2  Chapter Two

... etc.

The idea is (with a lot of simplification) that the user can write a paragraph and then assign it to any of the sections. I've used a query to pull together the paras and the section info using a left join and the result looks like this:

SN   Title          Para_ID      Para_Text
1    Chapter One
1.1  Background      93          This is an example para.
1.2  Introduction    97          Another example para
1.2  Introduction    99          Yet another sentence.
2    Chapter Two

I have a report based on this query which is grouped by SN and then by Para_ID, but my output looks like this:

1.1 Background
  This is an example para.
1.2 Introduction
  Another example para
  Yet another sentence.

so is missing any group headings that don't have any attached paras.

Is there any way I can force these group headings to appear.

Regards

John

 

[dhookom]

You can possibly change your report's query to include all the header records even if there are not any related records in your detail records.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.