reports: how to display totals only

[coline]

Hi, I'm trying to create a summary report in which I only show totals. I do not want to display any repeating data in the detail section. Ideally, I would use one query to display counts on multiple fields. My problem is that when I insert "=count[name of field in query]" in the details section, I get the correct count, but it repeats for the number of records in the query. How can I get the total to display once?

I have tried the other solution in which I compute the aggregate function in the query, but I'm not sure how to do this for more than one field, and I would like to avoid creating a query and subreport for each aggregate function.

Thanks for the help,
Coline

 

[Andrew Fergus]

Hi Coline
You mentioned that you inserted "=count[name of field in query]" into the detail section of the report. Try putting it into the report header or footer. If you can't see the report header or footer when in design mode then click on View -> Report Header / Footer. If this doesn't work post a reply.
HTH, Andrew.

 

[coline]

HI, thanks for the input. I tried doing this, but I kept getting an error.

Coline

 

[Andrew Fergus]

What sort of error are you getting? Can you explain it?

Can you get anything to show on the report at all? What does your query show at the moment? Have you tried creating a new report based on your existing query, adding just the totals (or counts) that you want into the report footer?

You can use unbound text boxes in the report footer with the following examples of control sources, without problems : "=Count([your field name])", "=Sum([your field name])", "=Max([your field name])", even if the fields are not shown in the detail section of the report.

Andrew

 

[SydneyGeek]

Hi Coline,

If you have the expressions correct as Andrew mentioned, the other possibility is that you put the textboxes on the Page Footer. IF you do that, Access spits the dummy.
You need to place the summary fields on footers related to the data, not the page, if you get the distinction.
Right-click any header / footer, select Sorting / Grouping. In the table, pick the field that you want to group by. Select to have a Group Footer, and / or a Group Header, and place the summary fields on these headers or footers.
Then you can delete the Detail section, and get the summary you were after.
{EDIT} -- By placing them in the Report Footer, you get grand totals / averages / whatever for the whole report. By placing them in the group footer, you get them by the logical grouping that you choose.

Denis

 

[coline]

Hi, thanks so much for the comments. It was the case that I was putting my total on the page footer - I didn't realize the difference. Thanks again!
C