Hello,
My database includes these tables:
Persons_Completed with an ID field (name + date completed primary key).
Data table with all entries linked by ID. Persons_Completed(one) ->Data(many).
My problem basically boils down to this:
I have a report that is using a parameterized query that is based on a join of the above two tables that is not totaled/grouped by in any way. I want a count in the report of grouped by ID as this will signify the number distinct records returned from the parameters. I cant get this directly because I need the data ungrouped for the report.
I realize this is a fairly common request (I’ve looked at SELECT DISTINCT), however I can’t figure out how to have this "total records" field use the same parameters that are entered when the form is opened without having to enter them in multiple times over.
Do I need to do something in vba to forward the parameters, a sub report, or can this simply be done with a correct query?
Thanks again for the help.
Side note: I posted a thread related to this db a couple of weeks back, but I think it would be more work to make all of the information relevant to this question apparent so I hope starting a new thread isn’t an issue.