473,385 Members | 1,356 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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

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

2 924
jimatqsi
1,271 Expert 1GB
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
Sackey
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

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

Similar topics

4
by: Andre Arpin | last post by:
I am new at sql so would appreciate some help I have the name of a table in alocal variable is it possible to select this table DECLARE @name sysname SET @name = 'tblSniffedItems' PRINT...
1
by: Geir Baardsen | last post by:
Hi! I might have a difficult cuestion. In our database we have registered different tyres with different dimensions from different suppliers that is both for summer and winter season. Now I...
17
by: Rico | last post by:
Hello, I am in the midst of converting an Access back end to SQL Server Express. The front end program (converted to Access 2003) uses DAO throughout. In Access, when I use recordset.AddNew I...
1
by: sgmarty | last post by:
Hi, I have an interesting problem. Without using reduncant data, how can I design a calculation field to get a running total from values in different records? I'm designing a usage/month report, and...
10
by: drago | last post by:
Hello guys again! Back with invoice problems. Just want to know how to store data in the main database in different tables and fields using a form. I have a datasheet view of a form where i have to...
1
by: san1014 | last post by:
Hi I have a table SQL> select * from nodes; NODE_ID NODE_NAME -------------------- ------------------------------ N1 Kothhapet N2 Nagole...
5
by: =?Utf-8?B?QW5kcmV3?= | last post by:
Hello, friends, I am testing our website (in 2003.net, c#) application. Sometimes there more values in Querystring, like ...
2
by: kveerareddy | last post by:
How can i get the total rows of a table: If i use "select count(*) from <tablename>" it will take lot of time to get the total row count. for example in MSSQL we have "SELECT ROWS FROM...
1
by: chennaibala | last post by:
hi frds... in my hiden textbox.i have following values... robert|true|true|false|arun|true|false|true|anu|true|true|false| i want to splits in to token and insert in mysql table in following...
3
by: 125a29 | last post by:
hi i'm trying to update total order cost in order table , basically what i want when i edit order item table such as changing quantity then it automatically update the total cost in order table i...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.