Get 1 total from repeating values

I have a query and a report using the query that I need help getting totals
on. The query gets records from several asset protection tables involving
theft, etc. There is 1 record per case # for each suspect involved in the
case, so each case # could have several suspects. The report needs to
display a total suspect count for each banner (company has 3 different
locations) which I have working properly just doing a count in the report,
but I'm dead in the water on getting 1 sum per case #. I've tried a lot of
different things between the query and the report to no avail. Example:
case #22 has 5 subjects, total theft amount = 71.77. The 71.77 is multiplied
5 times in the report and I only need it once. HELP! Please be specific if
you're kind enough to help me; I'm very tired this morning and not the
slickest thing when it comes to Access! TIA
.

Relevant Pages

  • Re: Report is making too many numbers
    ... from the $'s being listed more than once in the query. ... And you want to display the sum of in the Vendor header or footer ... My report is based on a query. ... those records--you could create a Totals query by depressing the ...
    (microsoft.public.access.reports)
  • Re: Can I add a summary in the report footer to do this...?
    ... The report's source is the Audit Details Query. ... There is another text box with a similar calculation, ... As the report runs through each BU it does the calcs, sums them up in the BU ... >>> Create a totals query similar to your report's record source. ...
    (microsoft.public.access.reports)
  • Re: Page totals error in report - doesnt add correctly
    ... display it on a form or report. ... query based on the Import Table. ... All Totals text boxes properties are set to General number with 2 decimal ...
    (microsoft.public.access.reports)
  • Re: Report with vertical columns
    ... As for the report, I have used a pivottable instead. ... use totals queries to get the total supplied and sold: ... Create a query using the Supply table. ... In the Field row, enter an expression that represents your date period. ...
    (microsoft.public.access.reports)
  • Re: Still Hoping for help with a Query problem
    ... the second query totals the found records. ... added to the report header. ... > entries for one product and 10 entries for another and so on. ...
    (microsoft.public.access.forms)