Count total and name wise

[janith]

Hi,

Just wanted to check what would be the control property for dcount function.. Which 1) will count the total records based on user field.
2) will count the total records based on user them self. ( customized based on user)
This I want to set as two labels titled as below on the form banner.

Total records saved:
Your contribution:

Thanks in advance for helping me out.

 

[plog]

Not really know what you are asking. Here's the reference for DCount: http://www.techonthenet.com/access/functions/domain/dcount.php

What have you tried and how is it not giving you what you expect?

 

[janith]

Not really know what you are asking. Here's the reference for DCount: http://www.techonthenet.com/access/functions/domain/dcount.php

What have you tried and how is it not giving you what you expect?

What I meant was under control property of the two labels that I mentioned I want the dcount function to count total records in the table and the total records based on the criteria of another text box. Hope this explains.

 

[spikepl]

So again, what have you tried that is not doing what is desired? Alternatively, what is not clear in the documentation link plog provided?

Just to be clear: on this site we help people do stuff (that they might find difficult on their own), but we do not do their work for them.