Access 2007 Master-Detail Report Question
Posted on 2010-01-03
I am trying to better understand how to get a detail subreport to display a message when there are no detail records. For example, I have a master record for an customer, but the customer has no orders (detail records). I would like a message to appear that says, "no orders", rather that just blank space. I played around with a few tables, but when there are no detail records, the detail subreport is omitted from the report. This includes any labels in the detail report, such as in the page and header sections.