Report Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to access so I certainly appreciate any help you can give me.

I want to create a report that shows the total amount of empy cells in the
colume titled "PaymentAmt". I also want to count the cells in that same
column that have amounts entered in them. Do I have to do this with a query
or can I do it in the report criteria and if so how would I do that. Thanks
in advance for your help.
 
A query can do that or you can use the DCount Function as the source of a
control

DCount("*","YourTableName","PaymentAmt is Null")
DCount("PaymentAmt","YourTableName")


In a query
SELECT Count(PaymentAmt) as Payments
, Abs(Sum(PaymentAmt Is Null)) as NoPayments
FROM YourTableName



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top