dcount

R

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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dcount -Date Criteria - Won´t find it - 0
DCount 2
Still struggling with DCount 9
Counting filtered records... 7
Dcount Problem 3
DCount problem redux 4
Dcount Error 1
Counting records on a form after filter 1

Top