Counting

I have a Report and I need to count data based on information contained
in other fields. For example, I need to count all the ID Numbers where
the completion status is 100% and the invoice amount is greater than 0.
I need to put this expression into a text box but I have come up with
some errors. If someone could give me a hand on how to do this it
would be appreciated.

Have you looked into Access HELP on the DCount() function? You might be
able to use an unbound textbox in your report and the DCount() function to
calculate your count.

(If you only say "I have come up with some errors", the newsgroup readers
don't have much to go on to help you. Specific descriptions encourage
specific suggestions.)

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor

"J" wrote in message
ups.com...
I have a Report and I need to count data based on information contained
in other fields. For example, I need to count all the ID Numbers where
the completion status is 100% and the invoice amount is greater than 0.
I need to put this expression into a text box but I have come up with
some errors. If someone could give me a hand on how to do this it
would be appreciated.