Dcount Question!

[Guest]

I have a report that has 2 different dates in it. The first date is used to
group the report which is the date an order was rcvd while the other is a
date that they enter if they complete. What I would to is count how many
records for each day that do not have the the completed date.

The following is my dcount but it has the wrong results as it counts
everything in the table instead of that date only.....
e.g.,
=Abs(DCount("[OrderID]","tblOrders",[Dcomplete]=Null & "[Rcvddate]=# " &
[Rcvddate] & "#"))

 

[Duane Hookom]

Assuming your text box is located in the Received Date header or footer
section:
=Sum(Abs(IsNull([DComplete])))

 

[Guest]

Thanks Duane,

I have another question, and I really need help, I don't know how to do it.
I have posted the question but no help yet....

I would like to know when a document was printed the first time by who and
the second time and thirrd time by who. One table has employee information
and the other table contains information where the report is derived from.

Please help!

Assuming your text box is located in the Received Date header or footer
section:
=Sum(Abs(IsNull([DComplete])))

--
Duane Hookom
MS Access MVP
--

I have a report that has 2 different dates in it. The first date is used
to
group the report which is the date an order was rcvd while the other is a
date that they enter if they complete. What I would to is count how many
records for each day that do not have the the completed date.

The following is my dcount but it has the wrong results as it counts
everything in the table instead of that date only.....
e.g.,
=Abs(DCount("[OrderID]","tblOrders",[Dcomplete]=Null & "[Rcvddate]=# " &
[Rcvddate] & "#"))