I have a pivot query that is populated with rates returned based on options that user selects on a form.
My issue is:
They can either select one lender to see on the report, or a combination of multiple lenders. The pivot table then has the lender's name, as a name of the column heading. The thing is....I need the report to print me the column name (as a heading) and all the values of all the records under that heading (or lender).
But Access references the column in the pivot query by the name, so if they select different lenders than what was in the pivot table for testing, I get an error that the field does not exist.
My question:
Is it possible....to have the report dynamically change the reference in the fields on the report to reflect the names of the column headings in the pivot table?
Please tell me yes....