By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,959 Members | 1,160 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,959 IT Pros & Developers. It's quick & easy.

Are dynamic reports possible in Access?

P: 88
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....
May 18 '07 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,343
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....
I can't say absolutely and unequivocally, but i think your answer is 'No' I'm afraid.
Jun 2 '07 #2

P: 88
Actually, I figured it out......I'll post the code once I get the time.

Thank you :)
Jun 4 '07 #3

NeoPa
Expert Mod 15k+
P: 31,343
Actually, I figured it out......I'll post the code once I get the time.

Thank you :)
Thanks. That would be great.
Jun 4 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.