By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,729 Members | 1,370 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,729 IT Pros & Developers. It's quick & easy.

How to total different values in a field in a table using the Dcount functionDCOUNT F

P: 9
i have a field in an access database Field name:Incidents. Table: IncidentT. in the incident field there are 3 types of incidents that are entered for employees ( injury, collision, and Inspection). i need to know how to get seperate totals for each incident for each employee on a form. tried to use the Dcount function, but keep getting errors (ie: the word name or some huge number). any help will be greatly appreciated

Thank you.
Jan 14 '15 #1

✓ answered by Sackey

i created a form using 2tables. one of the table has a field (incidents)with 3 different entries (collision,injury and accidents`). An employee can have all 3 or a combination. other information is pulled from another table (date of hire etc).i am trying to get a total for each entry for each employee and put onto a form. i tried to include screen shots, but its not working. let me know if you need more info. thank you

Share this Question
Share on Google+
2 Replies


Expert 100+
P: 1,240
Sackey, welcome to Bytes.com. Please provide sufficient detail to enable a good answer.

Are you working in a query, form or report? Or maybe you want some vba code. Dcount doesn't seem relevant to getting totals of anything. Counts, yes, totals no. DSum can total stuff. It could be you want a query with grouping and Sum().

Expand on your question, please.

Jim
Jan 14 '15 #2

P: 9
i created a form using 2tables. one of the table has a field (incidents)with 3 different entries (collision,injury and accidents`). An employee can have all 3 or a combination. other information is pulled from another table (date of hire etc).i am trying to get a total for each entry for each employee and put onto a form. i tried to include screen shots, but its not working. let me know if you need more info. thank you
Jan 20 '15 #3

Post your reply

Sign in to post your reply or Sign up for a free account.