Report to only show Totals

[Ineedcoffee]

Hi,

This might be really easy but can't seem to find anything on forums about it. I have a table of survey results in. The surveys have approx 10 questions and there are 2 of them. My grouping is by geographical area's.

All I want to be able to do is not show each individual record, but only the totals. I have created the total boxes in the geographical area header and thats working fine but just don't want to show all of the records underneath.

I also want to be able to create a simple bar chart off the totals of these fields.

Can anyone please help?


Thanks,

Ineedmorecoffee.

 

[gemma-the-husky]

hiding detail

- just set the detail section to visible = false


normally you would show the totals in the group footer - does it work without code in the header?

 

[Ineedcoffee]

Hey Dave,

Can't believe I missed that, knew it would be something simple. Yes it does work in the header without code, no idea why but it seems to be doing it.

I do now have 2 problems. I am trying to create a graph based on the 'summed' results and I can't see how to do this. Also the chart says you can only have a max field size of 7 however there are 10 questions.

Any idea's?

Thanks.

 

[Ineedcoffee]

I have managed to get a count for the records working along with the sum of the fields however for some strange reason I can't divide the two numbers.

It comes up with a message box asking me to input a value for IDTotals (this is the name of the text box that I have that counts the number of records in a group). I have this text box in the group footer however I have tried it in the header/detail aswell.

Any ideas?

Thanks.

 

[gemma-the-husky]

thats fine (the toals in the header) - i just wasnt sure if access had the totals at that stage - but it clearly does

it actually runs the report twice - once to paginate, and detemine the layout, etc , and then again to print it - so maybe it isnt surprising.

=============
now, to do calculations on sums etc, bascially you have to use the textbox names in the report not the underlying field names in the query.

so you might need to say =textbox12/textbox14

or, if you renamed them, then say

=grdtotals/itemcount


you could also amend the query to get the calcs inside the query - then you can use the fields - but for averages/percentages etc, this often is not feasible or correct

you can get issues with #name errors using control names that are also the names of fields - try renaming the controls - see if that helps
=============

 

[Ineedcoffee]

Thanks again, I have managed to get it to work. What I was doing is using a field and dividing that by the text box name.

I now have it so that it is showing loads of numbers after the decimal point and I have set the number of decimal points to 1 however this is also not working.

Probably will be something simple again but just can't see it.


Thanks