dcount question

[\Allen Iverson\]

I tried to use DCOUNT function in report in Access97. However it keeps
giving me #error. Is there anything special about this function? Is there
any other function I can use which is similar to DCOUNT?

 

[AlCamp]

Allen,
It would have been good if you had posted your DCount the way you typed
it, so we could check for a syntax problem.
A common #error is using a legitimate field name for your calculated
DCount field.
If you count field [Items] don't name the count field [Items]... use a
name like [CountOfItems] instead.
hth
Al Camp