J
judy j via AccessMonster.com
I need a report that displays all the count data of my crosstab query, but
not in the layout of the crosstab query.
My crosstab is a count of all staff for today; colums of 3 shifts & rows of 5
staff levels.
I want to layout my form using text fields that reference each of the
crosstab cells in the text field's controlSouce. Does Access have a format
to reference each of the cells?
I have tried various attempts at writing separate iif/count functions for
each of the 15 fields;
which even if it worked, would not be very efficient for each field to do
it's own query and count.
And then most successful has been 5 subforms for each staff level, and each
subform is based on a sum query of that staff level for all 3 shifts. This
works fine, but DOES take a long time to run calculations.
Seems like the most efficient would be referencing the cells of the crosstab,
but no clues on how that is done.
Any ideas? judy
not in the layout of the crosstab query.
My crosstab is a count of all staff for today; colums of 3 shifts & rows of 5
staff levels.
I want to layout my form using text fields that reference each of the
crosstab cells in the text field's controlSouce. Does Access have a format
to reference each of the cells?
I have tried various attempts at writing separate iif/count functions for
each of the 15 fields;
which even if it worked, would not be very efficient for each field to do
it's own query and count.
And then most successful has been 5 subforms for each staff level, and each
subform is based on a sum query of that staff level for all 3 shifts. This
works fine, but DOES take a long time to run calculations.
Seems like the most efficient would be referencing the cells of the crosstab,
but no clues on how that is done.
Any ideas? judy