I have an access database that I am trying to create a report from a query. The query contains information based on various departments. The report will need to list the topics on the left and have the department names aligned from left to right. I want to be able to read the data, calculate a percentage and display the answer under the correct department. It is similar to a crosstab query or a pivot table. I have the work on the code and I have it printing department #1 information everywhere. I can’t seem to get it to read the next department.
Here is a sample:
Standard…….Department01….Deparment 02..etc
Data correct……100%…………75%……….
Forms correct…..100%…………100%……..
The standards are hard coded in the report using a label. On the on format event, I go to the routine and and calculate the totals.
I know there is a design flaw, it would have been easier to have all the standards as records but this was inherited and I was told to produce this report. I know that this is feasible in VBA. I have a degree in programming and in my early years could get COBOL and BASIC to do anything. My knowledge of VBA is very limited.
Can anyone help? Is this as clear as mud?
Thanks,
Deborah
