Re: Counting blanks fields for a report

If that is the result you are getting than there are not records with no
value in the status field. Go back to your data and confirm this.

--
Duane Hookom
MS Access MVP


"Robin Chapple" <address@xxxxxxxxxxxxx> wrote in message
news:vbp1i19fj0o0m852bhvv4tknf6huldcpgg@xxxxxxxxxx
>
> Your description is the result that I need.
>
> The code supplies no data:
>
> The field shows: :18 = .%"
>
> In an attempt to prove parts of the expression I entered:
>
> =(Sum(IsNull([Status])))
>
> and the displayed result is: "0.00"
>
>
> Robin
>
> On Thu, 8 Sep 2005 00:04:52 -0500, "Duane Hookom"
> <duanehookom@xxxxxxxxxxxxxxxxxx> wrote:
>
>>Ok, lets see if I understand. You want to count the number of records in a
>>report that have a Null status field. You want to use this count as the
>>denominator in an expression. You want to format the expression as a
>>percent.
>>
>>Try:
>>
>>="18 =" & Format( IIf( Sum(IsNull([Status])) = 0,0,
>>1800/Sum(Abs(IsNull([Status])))),"#.##") & "%"
>


.

Relevant Pages

  • Re: Calculate a date based on period and year
    ... "Trevor Shuttleworth" wrote: ... when the report is pulled in the first quarter of any given year, ... How can I change the formula to show the period and year (format - ... Acct # Curr Period Prev Qtr End Prev Period Curr Period ...
    (microsoft.public.excel.worksheet.functions)
  • Using the NewRowOrCol property
    ... DESPERATE WORKER ... I am using the New Row Or Col property within my report to format my ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Time as 24hrs in report
    ... I have a report where time is expressed in 24hr format. ... Robin Chapple ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Date Question
    ... > I will have a query that will give me the most recent date that each of my ... > What procedure do I need to set up the report to do this. ... > Most specifically I am interested in the date format. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Counting blanks fields for a report
    ... The code supplies no data: ... >denominator in an expression. ... You want to format the expression as a ... Prev by Date: ...
    (microsoft.public.access.reports)