Display a Breakdown of Unique Reports in the Footer

[Damo1412]

Hi,

I am trying to produce statistics reports in my database. The user selects the information they require in a form (date from, date to etc). A query then produces the results listing each job in turn which is what I want however at the end I would like to produce sub-totals for each client.

Depending on the criteria selected by the user, only some clients will appear in the list. Ideally I would like the footer to show something like:

• Client 1 - 4 jobs
• Client 2 - 1 job
• Client 5 - 6 jobs
• Client 6 - 17 jobs

I have tried using the field:

=Count([ClientDetailsName])

However this only gives the total number of jobs.

Thanks for the help

 

[GinaWhipp]

I would suggest a subreport. Using the Count() function is not going to break it apart per Client unless you put it in the Client footer and then you would not see it the way you want.

 

[Damo1412]

Hi Gina,

Thanks for replying. Please excuse my ignorance here. I have used sub-reports a little bit to show the results of multiple queries on the same report but I am not sure how I would produce the desired result using a sub-report. Could you advise how I would go about doing this?

Thanks

 

[GinaWhipp]

Are you saying you can't create one query to show you the results above? Now, I am wondering about your table set-up.

 

[Damo1412]

I think that my tables are OK, the rest of the database is working fine, I'm just not sure how to produce a query that produces just the totals for each client.

 

[Damo1412]

Sorry to be a pain. I've just realised where I was going wrong with the query to show the totals.

Thanks for your help.

Damian

 

[GinaWhipp]

No, not a pain, you just needed another cup of coffee!