Expression Builder?

[Greta]

Access 2002...
What's the best way to get the total of "Not Null"s in a
bunch of items in a form?
The idea is that some of the items in one of the columns
will be "Fail"...I need a box at the bottom of the column
that tells me the total of "Fail"s. It will be blank if
the test doesn't fail.
Thanks,
Greta

 

[John Viescas]

One solution:

=Abs(DSum(Not IsNull([MyColumn])))

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)