(Msg. 1) Posted: Thu Jul 24, 2008 6:18 am
Post subject: count in report Add to elertz Archived from groups: microsoft>public>access>gettingstarted (more info?)
I can create a count on a field in a report but is there a way to force it to
only count specific names from that field.
Example: the field is tool_code which has up to 50 different tool codes
such as HF, HB, STFB, NCT...... and I only want the count of NCT's to show
up in my report.
(Msg. 2) Posted: Thu Jul 24, 2008 7:15 am
Post subject: RE: count in report Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=Count(IIf([FieldName]="NCT",1))
--
Wayne
Manchester, England.
"clcnewtoaccess" wrote:
> I can create a count on a field in a report but is there a way to force it to
> only count specific names from that field.
> Example: the field is tool_code which has up to 50 different tool codes
> such as HF, HB, STFB, NCT...... and I only want the count of NCT's to show
> up in my report.
>
> Hope this makes sense!
> --
> clcnewtoaccess
(Msg. 3) Posted: Thu Jul 24, 2008 8:13 am
Post subject: Re: count in report Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Thu, 24 Jul 2008 06:18:01 -0700, clcnewtoaccess wrote:
> I can create a count on a field in a report but is there a way to force it to
> only count specific names from that field.
> Example: the field is tool_code which has up to 50 different tool codes
> such as HF, HB, STFB, NCT...... and I only want the count of NCT's to show
> up in my report.
>
> Hope this makes sense!
=Sum(IIf([ToolCode]="NCT",1,0))
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other