Newbie Report Questions - Please Help

[steffenn]

My report is grouped by categories. If a category contains no records, I would like the phase, "No records this quarter" to appear in the Detail of that category.
I'm a beginner and was wondering if there is any simple code I can put into the report.
Your help appreciated.

 

[David R]

You posted this question yesterday. What was wrong with the answer you got then?

 

[jbruno]

 

[Pat Hartman]

Include the Category table in your query with a left join. This will force all category rows to the recordset even when there is no entry for the category in the main table. Then you can apply yesterday's answer

for the complete solution.

 

[Pat Hartman]

I just read yesterday's answer. You need something different.

In one of the controls of the Detail section -

=Nz(SomeField,"No Records for Quarter")