We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How do I reference the detail section of an access report to check if itis empty

nickmark
nickmark asked
on
Medium Priority
329 Views
Last Modified: 2012-06-21
I have a report that breaks on client. If there is no detail information for a client I want to display a text box that says "No information". I have the text box hidden and will change it to visible based on the trigger.
Problem - I have tried .HASDATA but it always returns true even if the detail section is empty.
I have dozens of clients and they are populated 95% of thie time. This will put the finishing touches on the report.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Try to use report event - On No Data and there set your control to visible

Author

Commented:
The report will always have data but some of the detail sections will not. For instance there will be data for 40 clients but no data for one. Can I put this on the report level or do I need something on the detail level. This report breaks on Ckient.
Thanks
CERTIFIED EXPERT

Commented:
Is client presented in source query if there are no data records? May be for your case is better to use subreports, where you can analyze - are there data or not
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thanks - I will modify the report. I appreciate your help!

Author

Commented:
Thanks - That is exactly what I ended up with as my solution.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.