Hi!
I've got a form, where the user can select a division or Group or region and it runs my query "Pivot Table by Division" with these parameters.
Now I have 30 columns in my QRY and I want the user to be able to select up to 5 of these colums (the capital ones, I only put 3 as an example):
Division Group Region FINANCIALSIZE EMPLOYEESIZE EBIT
Dubuque Book USA 1 2 3
Corinth Retail USA 3 4 1
I have no idea how to do this, I've tried everything! Please help ;-)
Thank you very much
I've got a form, where the user can select a division or Group or region and it runs my query "Pivot Table by Division" with these parameters.
Now I have 30 columns in my QRY and I want the user to be able to select up to 5 of these colums (the capital ones, I only put 3 as an example):
Division Group Region FINANCIALSIZE EMPLOYEESIZE EBIT
Dubuque Book USA 1 2 3
Corinth Retail USA 3 4 1
I have no idea how to do this, I've tried everything! Please help ;-)
Thank you very much