Hi,
I have about 100 records in a database. In each record there are 4 fields:
(1) Text field: yes/no (smoker?)
(2) Text field: (membername?)
(3) Text field: yes/no (Drink alcohol?)
(4) Date field
I have produced a report that, using parameters, asks the user for a date (start and end dates).
When the dates are given, a bar-chart is produced which shows:
1. (on the vertical axis) The amount of yes values in the smoker field.
2. (on the vertical axis) The different member names.
On the bars that are displayed, I want to get them so that the bars are split in 2 by different colours. The different colours representing the amount of 'drink alcohol' text field that are yes or no.
How can I get it to do this?
(I hope my drawing below helps)
Thanks
J
! ____
! ___ ! !
! ! ! ___ ! !
yes ! ! ! ! !
! ! ! ! ! ! !
! ! !
!_!__ !____!___! !___!__________________________
john peter mary ...............etc