Re: Counting blanks fields for a report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


The field [Status] is a calculated field from this:

Status: (IIf([ID]=1320,"Excused",IIf([EndLOA]>Date(),"LOA","")))

I am unaware of what the "" will put into the field. Nothing is
visible.

I experimented by adding a field to the query to give us numbers to
count:

Counted: IIf([Status]="LOA",1,0)

Counted: IIf([Status]="Excused",1,0)

Each of the above put a "1" into the field but this

Counted: IIf([Status]="LOA" or "Excused",1,0)

gives all fields as "0"

Is there a symbol for "Any character" ? The asterisk did not work.

Robin

On Thu, 8 Sep 2005 21:03:22 -0500, "Duane Hookom"
<duanehookom@xxxxxxxxxxxxxxxxxx> wrote:

>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.

.

Relevant Pages

  • Re: Search and compare
    ... FM will return records that fit EITHER criteria (an OR ... I had to create a calculated field in the child file to combine the ... Prev by Date: ...
    (comp.databases.filemaker)
  • Re: counting portal entries
    ... > which is a calculated field containing ... > FP6 windoze ... > Fritz Oppliger ... Prev by Date: ...
    (comp.databases.filemaker)
  • Re: FM8 crashes when using EventScript and printing
    ... I think I found an acceptable workaround: I set that calculated field ... as non-printing and now I can print. ... Prev by Date: ...
    (comp.databases.filemaker)
  • Re: How do I count a counted field.
    ... Robin ... >You can't have a function on a calculated field. ... >all countries" ... >Tom Lake ...
    (microsoft.public.access.gettingstarted)
  • calculatedfields
    ... These are ok but how do i create a calculated field adding the 2 values ... How can I get round this please without altering the titles. ... Geoff ... Prev by Date: ...
    (microsoft.public.excel.programming)