G
Guest
Hello,
I have built a crosstab query showing counts by crew numbers for a basis of
a graph that will be shown by only 'Inside' and 'Outside'. I would like to
group together in the crosstab all the 'outside' crews i.e. Crew 1,2,3 and
show them all together in the crosstab as 'Outside'; conversely, I would like
to group together 4,5,6 and show them all together as 'Inside'.
Is anyone able to provide me with the expression to do this.
Thank you
I have built a crosstab query showing counts by crew numbers for a basis of
a graph that will be shown by only 'Inside' and 'Outside'. I would like to
group together in the crosstab all the 'outside' crews i.e. Crew 1,2,3 and
show them all together in the crosstab as 'Outside'; conversely, I would like
to group together 4,5,6 and show them all together as 'Inside'.
Is anyone able to provide me with the expression to do this.
Thank you