Re: Counting blanks fields for a report

What section is this text box in?
What values do you expect to see? From my perspective, they are all 100%
correct.

--
Duane Hookom
MS Access MVP
--

"Robin Chapple" <address@xxxxxxxxxxxxx> wrote in message
news:h13rh1h3tn1hquinjjkdgnmj3dol676169@xxxxxxxxxx
> The first three expressions all show 0.00 and last displays no data at
> all.
>
> Robin Chapple
>
> On Mon, 5 Sep 2005 19:27:18 -0500, "Duane Hookom"
> <duanehookom@xxxxxxxxxxxxxxxxx> wrote:
>
>>What do you mean by "failed"? What do you get if you start small and then
>>add on:
>>=Sum(IIf([Status]="y",1,0))
>>Next change to:
>>=IIf(Sum(IIf([Status]="y",1,0))=0,0,99999)
>>Next change to:
>>=IIf(Sum(IIf([Status]="y",1,0))=0,0,18/Sum(IIf([Status]="y",1,0)) )
>>Next change to:
>>=Format(
>>IIf(Sum(IIf([Status]="y",1,0))=0,0,18/Sum(IIf([Status]="y",1,0)) ),"#.##")
>>--
>>Duane Hookom
>>MS Access MVP
>


.

Relevant Pages

  • Re: Beginner query help please
    ... MS Access MVP ... I've noticed that if you select all the query output (in this case ... Duane Hookom wrote: ... Controls in most query solutions would not be ignored. ...
    (microsoft.public.access.queries)
  • Re: Adding a ck mark?
    ... Duane Hookom ... MS Access MVP ... "txt1" is the name of a control in the detail section, ... Let's start a new report. ...
    (microsoft.public.access.reports)
  • Re: Unable to open forms or reports
    ... Is the drop-down bound to a field? ... MS Access MVP ... The exact expressions are as follows of the subforms. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.forms)
  • Re: Crosstab Report
    ... MS Access MVP ... I try to write the report my headings/totals crash. ... "Duane Hookom" wrote: ... some of the information you posted to the query and found it very ...
    (microsoft.public.access.reports)
  • Re: Subreport vs queryquestion
    ... detail section is shortened to only accomodate the size of the controls. ... Duane Hookom ... MS Access MVP ... What section of the report are the controls in? ...
    (microsoft.public.access.reports)
Loading