Hi,
I have created a database to track the training competency matrix. The way I did it is using the crosstab query. The database is working fine but I spend a lot of time doing manual stuff for the report as my column numbers change.
Let me explain. I have lets say 10 manufacturing areas. Each manufacturing area have operators that range from 3 individuals to 15 individuals. Also each area have their unique documentations that also ranger in number.
The way I have the crosstab query is the documents are "Row Heading" and the operator name is "Column Heading". What I am thinking is to link the crosstab query with a criteria from a form (e.g: [Forms]![frmChooseArea3]![strDpt]) which asks the User what area interested in and the crosstab query is created filtering the correct documents and operator names.
The problem I am having now is I have to manually go into the report design and add or delete columns depending on the area the User wants. I also have to once adding the right columns need to link them to the fields that matches the crosstab query and rename the field headers also.. Its cumbersome
Is there a vba I can use that will do that but adding and or deleting columns within the report and renaming the fields headers and linking to the query output.
Thanks in advance for anyone who can chime in
RB
I have created a database to track the training competency matrix. The way I did it is using the crosstab query. The database is working fine but I spend a lot of time doing manual stuff for the report as my column numbers change.
Let me explain. I have lets say 10 manufacturing areas. Each manufacturing area have operators that range from 3 individuals to 15 individuals. Also each area have their unique documentations that also ranger in number.
The way I have the crosstab query is the documents are "Row Heading" and the operator name is "Column Heading". What I am thinking is to link the crosstab query with a criteria from a form (e.g: [Forms]![frmChooseArea3]![strDpt]) which asks the User what area interested in and the crosstab query is created filtering the correct documents and operator names.
The problem I am having now is I have to manually go into the report design and add or delete columns depending on the area the User wants. I also have to once adding the right columns need to link them to the fields that matches the crosstab query and rename the field headers also.. Its cumbersome
Is there a vba I can use that will do that but adding and or deleting columns within the report and renaming the fields headers and linking to the query output.
Thanks in advance for anyone who can chime in
RB
