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.