Summing a specific records

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I want to get the sum of records based on a specific record filter (field
value), in addition to the report total which is the sum of all records. Is
there a way to do that in a report?

Thanks

Regards
 
You could do this in your query that is running the report. Make an expression like
NewNumber: IIF([FieldValue]>100,[Number],0

Then, on your report you can do a sum of the [NewNumber] field

Hope this helps

----- John wrote: ----

H

I want to get the sum of records based on a specific record filter (fiel
value), in addition to the report total which is the sum of all records. I
there a way to do that in a report

Thank

Regard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

summing in a report 3
Access Sum function in an Access Form 1
how to sum per page & per all report 1
summing values in each record (summing across rows) 2
Records Created Sum per Day 1
Rpt totals of datediff field only if checkbox of another field che 1
form requery, first record problem 11
Running sum on report 4

Back
Top