I'm working with MS Access 2013.
I build a report. I would like to add a second tie to my report with another query I titled PDCqry. the relationship between them both is the Collector_Code field. the PSB Fee's Collected and Goal Projection query will be the top tie and only have one field for each Collector_Code field.
PDCqry query has many records that and would be the second tie in the report. I might be changing the fields later, but for now this is what I'm looking for.
Ask for password if interested