Re: Counting blanks fields for a report

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: Printing a fixed date next year
    ... <MS ACCESS MVP> ... >I need to print membership cards which show ... > Robin Chapple ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • Re: Criteria for date
    ... >Try putting the various expressions into vacant Field cells just to ... Robin Chapple ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Counting blanks fields for a report
    ... > Robin Chapple ... >>Duane Hookom ... >>MS Access MVP ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Combo Box field look up
    ... Post the SQL statement of the form's recordsource. ... <MS ACCESS MVP> ... "Robin Chapple" wrote in message ... >>Delete the control that is bound to it, and close the form. ...
    (microsoft.public.access.gettingstarted)
  • Re: Percentages...gone awry.
    ... > expressions but i also have a few precentage fields. ... integer types; probably Long Integer, but maybe Integer or even Byte. ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.forms)