dcount

[RayNDM83]

Hi,
I have a textbox in my form header and was trying to use DCount function in
it. What I would like to do is to use DCount function that if I filter the
detail, it would DCount just what is within the filtered detail. The Count
function works with filtered forms but not the DCount form.
Could someone help me out?
Thanks,
Ray
ps. I'm using access 2007.

 

[scott04]

Ray,

I have really only used dcount when i wanted something counted from a table
not used by my control source. I found this info which may help:

If you simply want to count all records in domain without specifying any
restrictions, use the Count function.

You can use the DCount function to count the number of records containing a
particular field that isn't in the record source on which your form or report
is based. For example, you could display the number of orders in the Orders
table in a calculated control on a form based on the Products table.