Hi Guys,
Fairly new to Access and using 2007 if that helps.
I have a report with a sub-report. Both work !
The Main Report is a client statement and the subreport lists all receipts made by that client.
The issue I would like to tidy up is if there are no payments made i.e. no records in the receipts table. I would like to display if there are no records "No Payments Rec'd"
I have had a play with "hasdata" but own upto being a little out of my depth.
I would appreciate any guidance you can offer.
Cheers,
Rob
Fairly new to Access and using 2007 if that helps.
I have a report with a sub-report. Both work !
The Main Report is a client statement and the subreport lists all receipts made by that client.
The issue I would like to tidy up is if there are no payments made i.e. no records in the receipts table. I would like to display if there are no records "No Payments Rec'd"
I have had a play with "hasdata" but own upto being a little out of my depth.
I would appreciate any guidance you can offer.
Cheers,
Rob
