If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sum group great than 5,000
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. |
#2
|
|||
|
|||
sum group great than 5,000
On Wed, 23 Nov 2005 14:31:03 -0800, Gary Williamson, RE wrote:
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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
sum group great than 5,000
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" wrote: On Wed, 23 Nov 2005 14:31:03 -0800, Gary Williamson, RE wrote: 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
query won't import to excel | Thos @ fodc | Running & Setting Up Queries | 1 | November 2nd, 2005 12:59 AM |
ambiguous outer joins | renwick | Running & Setting Up Queries | 3 | February 22nd, 2005 01:29 PM |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
Group Naming | Group Me | Outlook Express | 1 | August 9th, 2004 05:52 AM |
Group By | Running & Setting Up Queries | 3 | August 5th, 2004 10:37 PM |