Pull only Total from Tables

[sujitshukla]

Hi All,

I am having a small problem here. I am creating reports for about 600 agents who handle 18 skills. So the data dump usually for 1 day ranges from 1800-2700 rows and might increase. So i thought of exporting this data in access since the excel file becomes 2 heavy.

My problem is if i want to get only the summary from the Access database, how will i do that.
Like i want to know how many calls handled on each day and what was the AHT.

Appreciate your help

Thanks
Sujit Shukla

[maximus]

Dcount is something that you can use:

Example i would like the count of names in my Table tblmember:
Dcount("[MemberName]","tblmember")

Example I would Like the count of all members that are Registered:
DCount("[MemberName]","tblmember","[Registered]=True")

Example I would Like the count of all the members whose date of Birth is Between 01/07/2000 and 01/07/2001

Dcount("[MemberName]","tblMember","[Dob] Between #01/07/2000# And #01/07/2001#")

These are some examples.

Dcount can be used in Calculative fields in queries and also in the control source of from objects like TextBoxes.