troubleshooting Question

Subreports in Access

Avatar of prophet001
prophet001 asked on
* msaccess reportsMicrosoft Access* Access 2019* Access
5 Comments1 Solution28 ViewsLast Modified:
Hello. I was wondering if someone might help me understand subreports in access a little better. I have a main report that gives a list of jobs filtered by a parameter that does a WHERE [JobNumber] LIKE Parameter query and returns the list of records.

This main report has a subreport that aggregates the values into a total subreport. It works without issue for the most part but a few things are odd to me. For example, if the main report has no results (the parameter was blank or the job number wasn't found) then the subreport will still show records from the database for some reason. Also, if I use a parameter like "1234*" then the main report will return all records like 1234A or 1234B etc. However, the subreport will only return records from the first JobNumber and not both.

The master and child fields are linked on JobNumber. I guess I was under the impression that the subreport would only show records from the main report but there seems to be something else that it is doing. Why does it show records when the main report doesn't? Why doesn't it show all of the records of the main report?

Thank you for your help.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros