M
MacNut2004
Hello!
I have a report that is using a crosstab query...where the column headings
are determined by VBA code -- A,B,C,D, etc etc depending on the amount of
categories that particular month. In my report, I have a calculated field
called "BIllable Percent" which is the project billable hours divided by the
total hours. In this situation where I ran the report today, the project
billable hours is assigned field "D" but next week, it could be assigned
field "E" depending on if another category comes into play that happens to be
earlier in the alphabet, which would screw up the calculation. (since it's in
alphabetical order)
Can anyone help me with this?
Thank you!
MN
I have a report that is using a crosstab query...where the column headings
are determined by VBA code -- A,B,C,D, etc etc depending on the amount of
categories that particular month. In my report, I have a calculated field
called "BIllable Percent" which is the project billable hours divided by the
total hours. In this situation where I ran the report today, the project
billable hours is assigned field "D" but next week, it could be assigned
field "E" depending on if another category comes into play that happens to be
earlier in the alphabet, which would screw up the calculation. (since it's in
alphabetical order)
Can anyone help me with this?
Thank you!
MN