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.
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.
