Hi,
I have a query in access which fetches Records based on a parameter supplied by the user at runtime. parameter "Enter Date:"
Now I created a Report to display the above results.
There could be occasions where there could be no records avaiable.
During those occasion a message needs to be displayed "No Records available for this date."
I was thinking of putting an invisible Label, in the pageHeader section, to do this job, which becomes visible only when there is no record fetched in the detail section. Some coding in this regard would be of much help.
Thanks in advance