G
Guest
I have a very simple data base (no relationships) and data is only entered
once. In my report, I placed the data in the group footer because the detail
section shows duplicate data. I have gone through all of the properties and
made sure the hide duplicates is marked yes. However, I am still getting
duplicate label boxes and the data seems to be be split. For instance -
there are currently eight records in the main table. For a single field
[qol1] each record selects 1 - 5 from a combo box. When I designed the
report, I separate these out using the formula
=Sum(IIf([qol1]="1",1,0))
=Sum(IIf([qol1]="2",1,0))
etc. to tally the responses. The report then displays the question labels
twice and does not combine the data. The report comes out looking like the
example below.
Ex:
1
2 3 4 5
1. On a scale of 1 to 5 how happy are you? 0 0 0 0
2
2. On a scale of 1 to 5 rate your self esteem 0 1 4 0
0
---------------------------------------------------------------------------------------------
1
2 3 4 5
1. On a scale of 1 to 5 how happy are you? 0 1 4 0
0
2. On a scale of 1 to 5 rate your self esteem 0 0 0 0
0
---------------------------------------------------------------------------------------------
1
2 3 4 5
1. On a scale of 1 to 5 how happy are you? 0 0 0 0
0
2. On a scale of 1 to 5 rate your self esteem 0 0 0 0
2
1 - 5 the degree of the respondents answer and the numbers in each column
are the number of responses for that degree. I am trying to figure out how
to combine the data and eliminate the duplicate labels. I have copied this
report and the formula from an existing database that works just fine
(changing the necessary information of course).
Any help would be appreciated.
Thanks.
once. In my report, I placed the data in the group footer because the detail
section shows duplicate data. I have gone through all of the properties and
made sure the hide duplicates is marked yes. However, I am still getting
duplicate label boxes and the data seems to be be split. For instance -
there are currently eight records in the main table. For a single field
[qol1] each record selects 1 - 5 from a combo box. When I designed the
report, I separate these out using the formula
=Sum(IIf([qol1]="1",1,0))
=Sum(IIf([qol1]="2",1,0))
etc. to tally the responses. The report then displays the question labels
twice and does not combine the data. The report comes out looking like the
example below.
Ex:
1
2 3 4 5
1. On a scale of 1 to 5 how happy are you? 0 0 0 0
2
2. On a scale of 1 to 5 rate your self esteem 0 1 4 0
0
---------------------------------------------------------------------------------------------
1
2 3 4 5
1. On a scale of 1 to 5 how happy are you? 0 1 4 0
0
2. On a scale of 1 to 5 rate your self esteem 0 0 0 0
0
---------------------------------------------------------------------------------------------
1
2 3 4 5
1. On a scale of 1 to 5 how happy are you? 0 0 0 0
0
2. On a scale of 1 to 5 rate your self esteem 0 0 0 0
2
1 - 5 the degree of the respondents answer and the numbers in each column
are the number of responses for that degree. I am trying to figure out how
to combine the data and eliminate the duplicate labels. I have copied this
report and the formula from an existing database that works just fine
(changing the necessary information of course).
Any help would be appreciated.
Thanks.