Count Records

[Phil Krenzer]

Is their a way to count records of a populated field only and not the blanks that are in the same field. Tried using the count function along with the isblank and isnotblank but can't seem to get it to work.

[madtowng]

Hi Phil,
This is one of those times that it's helpful to post the code that isn't working as expected.

Gregg

[Phil Krenzer]

Hi Gregg,

2 of the fields in the app are a proposal number field and an invoice number field. The invoice number field contains some blank records as not all of the proposals are accepted. The code I am using for the invoice field is --- if(isnotblank("Invnbr"),count(acpt->invnbr,grp->Estmtr,grp->Detail),0). Am getting 0 count for invoice field.

Phil

[Phil Krenzer]

Gregg disregard my last will get back to you later have to leave for a bit

[Ronald Anusiewicz]

Is this something you want to do?

[Tom Cone Jr]

Phil,
from the helps... in discussion of Count()...

This function is a report writer function, not intended for table level field rules or other expressions. While the function may perform in some areas outside of the report writer, its use there is not supported

[Tom Cone Jr]

Phil,

I've extended Ron's good example.

-- tom

[Phil Krenzer]

Tom and Ron
Thanks for your input. I'm working on it will let you know outcome. Thanks again.
Phil

[MoGrace]

If you add a session variable and place it on the form you can omit the button and use the OnFetch event to update the non-blank count

dim shared nrecs as N
nrecs = a5_get_records_in_query("authors", "nationality <> /"/" ")
vnrecs.refresh()

(replace the forward slash with a backslash or use singe quotes)