A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

sum group great than 5,000



 
 
Thread Tools Display Modes
  #1  
Old November 23rd, 2005, 11:31 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old November 23rd, 2005, 11:39 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old November 24th, 2005, 07:38 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 01:59 AM
ambiguous outer joins renwick Running & Setting Up Queries 3 February 22nd, 2005 02:29 PM
Syntax needed to get needed reports Frank Lueder New Users 15 January 6th, 2005 09: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


All times are GMT +1. The time now is 07:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.