sum group great than 5,000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field named owner_name1 with several identical records the report
sums the total_acres field for owner_name1 ok but I only want total_acres > a
certain variable say 5,000. I cannot get it to work.
 
I have a field named owner_name1 with several identical records the report
sums the total_acres field for owner_name1 ok but I only want total_acres > a
certain variable say 5,000. I cannot get it to work.
Click to expand...

I'll have to guess at what you want.

=Sum(IIf([SomeField]>5000,[SomeField],0))

Next time try using better punctuation to make what you want to say
more intelligible to others.
 
Fred,
Thanks for the response. Below is the code from the report. It summarises
all identical "ownr_nam1" records and gives me the "tot_acres" associated
with that owner. Iam getting the report I need but it is 2,000 pages+. Iam
not sure where to place the parameter to eliminate owners of total acres
<1,000 or <5,000 etc. so the report only shows owners of large acerages.
Iam analyzing 800,000+ records. Iam an old rpg programmer (30years ago) and
have not been able to figure out the newer languages coding rules or
instuctions or formulas etc. any suggestions. I will try your suggestion in
the tot acres column

Thanks for your help.

column 1 'OWNR_NAM1' :
="Summary for " & "'OWNR_NAM1' = " & " " & [OWNR_NAM1] & " (" & Count(*) & "
" & IIf(Count(*)=1,"detail record","detail records") & ")"

column 2 TOT_ACRES:
=Sum([TOT_ACRES])

fredg said:
I have a field named owner_name1 with several identical records the report
sums the total_acres field for owner_name1 ok but I only want total_acres > a
certain variable say 5,000. I cannot get it to work.
Click to expand...

I'll have to guess at what you want.

=Sum(IIf([SomeField]>5000,[SomeField],0))

Next time try using better punctuation to make what you want to say
more intelligible to others.
Click to expand...
 
Back
Top