If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I'm stuck can not get total sum correct
I have been working on this for a while, I have restarted my database it
works fine. Now I need to get total for accident per employee and the total for accident per departments. This is what I have done thus far, I have put a footer on my report for each grouping employee total and dept total. This is the expression that I am using =Sum([Department]) and for employees =Sum([EmployeeID]). Using this expression I get a mismatch data type. Any help is appreciation. -- LHEMA |
#2
|
|||
|
|||
I'm stuck can not get total sum correct
Try This =Sum(nz([Department]))
and =Sum(nz([EmployeeID])) "LHEMA" wrote: I have been working on this for a while, I have restarted my database it works fine. Now I need to get total for accident per employee and the total for accident per departments. This is what I have done thus far, I have put a footer on my report for each grouping employee total and dept total. This is the expression that I am using =Sum([Department]) and for employees =Sum([EmployeeID]). Using this expression I get a mismatch data type. Any help is appreciation. -- LHEMA |
#3
|
|||
|
|||
I'm stuck can not get total sum correct
I get a data mismatch when i try those two. I use this expression and I am
not getting a numeric answer here is the expression: =nz(DLookUp("Department","[qry Employee Accident]"),0) the results from this expression is the department number such as 42200 Road Dept and and for employee total i use this expression: =Sum(nz([EmployeeID])) and its giving me a total of the employeeID not a numeric value of 1 or 2. I have 3 reports and in each report I need a separate total for each employee. If Robert had 3 accident in this department then I need to see in my report employee total = 3 and department total =3 but if John gets 1 accident in the road department I need to see on john report employee total=1 and department total=4...I hope I am making since. Thank you -- LHEMA "Crazyhorse" wrote: Try This =Sum(nz([Department])) and =Sum(nz([EmployeeID])) "LHEMA" wrote: I have been working on this for a while, I have restarted my database it works fine. Now I need to get total for accident per employee and the total for accident per departments. This is what I have done thus far, I have put a footer on my report for each grouping employee total and dept total. This is the expression that I am using =Sum([Department]) and for employees =Sum([EmployeeID]). Using this expression I get a mismatch data type. Any help is appreciation. -- LHEMA |
#4
|
|||
|
|||
I'm stuck can not get total sum correct
Are you attempting to count the number of employees? What field needs to be
Sum()'d? -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... I have been working on this for a while, I have restarted my database it works fine. Now I need to get total for accident per employee and the total for accident per departments. This is what I have done thus far, I have put a footer on my report for each grouping employee total and dept total. This is the expression that I am using =Sum([Department]) and for employees =Sum([EmployeeID]). Using this expression I get a mismatch data type. Any help is appreciation. -- LHEMA |
#5
|
|||
|
|||
I'm stuck can not get total sum correct
Department and EmployeeID are of text values, you can't add them.
Do something like, Count([Department]) Count([EmployeeID]) LHEMA wrote: I get a data mismatch when i try those two. I use this expression and I am not getting a numeric answer here is the expression: =nz(DLookUp("Department","[qry Employee Accident]"),0) the results from this expression is the department number such as 42200 Road Dept and and for employee total i use this expression: =Sum(nz([EmployeeID])) and its giving me a total of the employeeID not a numeric value of 1 or 2. I have 3 reports and in each report I need a separate total for each employee. If Robert had 3 accident in this department then I need to see in my report employee total = 3 and department total =3 but if John gets 1 accident in the road department I need to see on john report employee total=1 and department total=4...I hope I am making since. Thank you Try This =Sum(nz([Department])) and =Sum(nz([EmployeeID])) [quoted text clipped - 6 lines] =Sum([EmployeeID]). Using this expression I get a mismatch data type. Any help is appreciation. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200604/1 |
#6
|
|||
|
|||
I'm stuck can not get total sum correct
Using those expression it counts all them I need for them to count each
department and employee separately on their report. If John have 2 accident in the Road Dept I need to see on John report dept Total 2 and Empoyee total=2 but if Steve get and accident in the Road Dept I need for Steve to show on his report dept total =3 and employee total=1. Likewise with the rest, the count for employees does not work at all I get zero for the result. I use this function and I am getting character for my results not a numeric answer =nz(DLookUp("Department","[qry Employee Accident]"),0) any help is appreciated -- LHEMA "AccessVandal via AccessMonster.com" wrote: Department and EmployeeID are of text values, you can't add them. Do something like, Count([Department]) Count([EmployeeID]) LHEMA wrote: I get a data mismatch when i try those two. I use this expression and I am not getting a numeric answer here is the expression: =nz(DLookUp("Department","[qry Employee Accident]"),0) the results from this expression is the department number such as 42200 Road Dept and and for employee total i use this expression: =Sum(nz([EmployeeID])) and its giving me a total of the employeeID not a numeric value of 1 or 2. I have 3 reports and in each report I need a separate total for each employee. If Robert had 3 accident in this department then I need to see in my report employee total = 3 and department total =3 but if John gets 1 accident in the road department I need to see on john report employee total=1 and department total=4...I hope I am making since. Thank you Try This =Sum(nz([Department])) and =Sum(nz([EmployeeID])) [quoted text clipped - 6 lines] =Sum([EmployeeID]). Using this expression I get a mismatch data type. Any help is appreciation. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200604/1 |
#7
|
|||
|
|||
I'm stuck can not get total sum correct
What I need to so count the number of employees that had an accident and each
employee should have a separate report with the total of accident they have had. And for the department it should count only the accidents in that department not a all department. I use this expression and I am getting a character for result what I mean is that I am getting the name of the Dept and not the numeric number =nz(DLookUp("Department","[qry Employee Accident]"),0) =count([employeeID]) I hope I answer your question -- LHEMA "Duane Hookom" wrote: Are you attempting to count the number of employees? What field needs to be Sum()'d? -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... I have been working on this for a while, I have restarted my database it works fine. Now I need to get total for accident per employee and the total for accident per departments. This is what I have done thus far, I have put a footer on my report for each grouping employee total and dept total. This is the expression that I am using =Sum([Department]) and for employees =Sum([EmployeeID]). Using this expression I get a mismatch data type. Any help is appreciation. -- LHEMA |
#8
|
|||
|
|||
I'm stuck can not get total sum correct
Why don't you take the time to type in about 10-12 records to show us
exactly what you want in your report. This would save a whole lot of guessing and only take you about a minute. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... What I need to so count the number of employees that had an accident and each employee should have a separate report with the total of accident they have had. And for the department it should count only the accidents in that department not a all department. I use this expression and I am getting a character for result what I mean is that I am getting the name of the Dept and not the numeric number =nz(DLookUp("Department","[qry Employee Accident]"),0) =count([employeeID]) I hope I answer your question -- LHEMA "Duane Hookom" wrote: Are you attempting to count the number of employees? What field needs to be Sum()'d? -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... I have been working on this for a while, I have restarted my database it works fine. Now I need to get total for accident per employee and the total for accident per departments. This is what I have done thus far, I have put a footer on my report for each grouping employee total and dept total. This is the expression that I am using =Sum([Department]) and for employees =Sum([EmployeeID]). Using this expression I get a mismatch data type. Any help is appreciation. -- LHEMA |
#9
|
|||
|
|||
I'm stuck can not get total sum correct
ok..I will let you know the results
-- LHEMA "Duane Hookom" wrote: Why don't you take the time to type in about 10-12 records to show us exactly what you want in your report. This would save a whole lot of guessing and only take you about a minute. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... What I need to so count the number of employees that had an accident and each employee should have a separate report with the total of accident they have had. And for the department it should count only the accidents in that department not a all department. I use this expression and I am getting a character for result what I mean is that I am getting the name of the Dept and not the numeric number =nz(DLookUp("Department","[qry Employee Accident]"),0) =count([employeeID]) I hope I answer your question -- LHEMA "Duane Hookom" wrote: Are you attempting to count the number of employees? What field needs to be Sum()'d? -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... I have been working on this for a while, I have restarted my database it works fine. Now I need to get total for accident per employee and the total for accident per departments. This is what I have done thus far, I have put a footer on my report for each grouping employee total and dept total. This is the expression that I am using =Sum([Department]) and for employees =Sum([EmployeeID]). Using this expression I get a mismatch data type. Any help is appreciation. -- LHEMA |
#10
|
|||
|
|||
I'm stuck can not get total sum correct
I have added 10 more records and the expression is use for deparment:
=Count([Department]) and employee: =Count([EmployeeID]) and the results that i am getting is 1 for everybody -- LHEMA "LHEMA" wrote: ok..I will let you know the results -- LHEMA "Duane Hookom" wrote: Why don't you take the time to type in about 10-12 records to show us exactly what you want in your report. This would save a whole lot of guessing and only take you about a minute. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... What I need to so count the number of employees that had an accident and each employee should have a separate report with the total of accident they have had. And for the department it should count only the accidents in that department not a all department. I use this expression and I am getting a character for result what I mean is that I am getting the name of the Dept and not the numeric number =nz(DLookUp("Department","[qry Employee Accident]"),0) =count([employeeID]) I hope I answer your question -- LHEMA "Duane Hookom" wrote: Are you attempting to count the number of employees? What field needs to be Sum()'d? -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... I have been working on this for a while, I have restarted my database it works fine. Now I need to get total for accident per employee and the total for accident per departments. This is what I have done thus far, I have put a footer on my report for each grouping employee total and dept total. This is the expression that I am using =Sum([Department]) and for employees =Sum([EmployeeID]). Using this expression I get a mismatch data type. Any help is appreciation. -- LHEMA |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculating Business Hours Between 2 Dates | tanya216 | General Discussion | 2 | April 11th, 2006 03:22 PM |
not correct running total in group | cmk | Setting Up & Running Reports | 0 | November 10th, 2005 04:30 PM |
More of a math question,but I am stuck getting a correct figure. | Michael | Using Forms | 6 | August 2nd, 2005 02:33 PM |
help needed | jkendrick75 | Running & Setting Up Queries | 19 | March 17th, 2005 02:37 PM |
Grand Total Problem | PW11111 | Running & Setting Up Queries | 2 | March 11th, 2005 05:44 PM |