Add Count to a Report with multiple Null Criteria (Expression Builder Syntax)

[efmbman]

Sorry if this has been asked/answered elsewhere. My search ability is limited based on my knowledge of terms...



I have a report in which I would like to add some counts based on a table. Here is the statement I have that returns an error:

= Count ( [FormData]![INITSTFF] Is Not Null , [FormData]![INITVET] Is Null , [FormData]![DISCHRG] Is Null )

FormData is my table.
INITSTFF, INITVET, and DISCHRG are date fields.

The error is get is: "The expression you entered has a function containing the wrong number of arguments."

What am I doing wrong?

[rpeare]

What are you trying to count?

Any item where INITSTFF is not null AND INITVET AND DISCHRG are both null?

if you wanted that you'd have to have

=sum(iif(not isnull(initstff) AND (isnull(INITVET) AND (isnull(DISCHRG)), 1, 0))

[efmbman]

What are you trying to count?

Any item where INITSTFF is not null AND INITVET AND DISCHRG are both null?

if you wanted that you'd have to have

=sum(iif(not isnull(initstff) AND (isnull(INITVET) AND (isnull(DISCHRG)), 1, 0))

Thanks, but still get the same error.

[rpeare]

look at the bracketing

=sum(iif(not isnull(initstff) AND (isnull(INITVET) AND isnull(DISCHRG)), 1, 0))

[efmbman]

look at the bracketing

=sum(iif(not isnull(initstff) AND (isnull(INITVET) AND isnull(DISCHRG)), 1, 0))

Yep... found it. All the [()] add up now. However, a new error appears: "The specified field could refer to more than one table listed in the FROM clause of your SQL statement."

I did not type the field names, I chose them using the expression builder thinking that was the best way to point at the correct item. I have no idea how to even get at the SQL...

[rpeare]

so put your table name back in then

[tablename]![fieldname]

[efmbman]

so put your table name back in then

[tablename]![fieldname]

Right, I did that from the beginning assuming you were doing the example shorthard. I do appreciate the help, but it seems I am getting nowhere.

[rpeare]

Then there's some other field in your query that you're using in a formula that could be from multiple tables, look at all your formula fields and examine them for field names that occur in more than one table.