A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

I'm stuck can not get total sum correct



 
 
Thread Tools Display Modes
  #1  
Old April 18th, 2006, 08:17 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old April 18th, 2006, 08:42 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old April 18th, 2006, 08:53 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old April 19th, 2006, 04:19 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old April 19th, 2006, 08:23 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old April 19th, 2006, 01:21 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old April 19th, 2006, 01:27 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old April 19th, 2006, 01:54 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old April 19th, 2006, 02:29 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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  
Old April 19th, 2006, 04:54 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 05: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 03:37 PM
Grand Total Problem PW11111 Running & Setting Up Queries 2 March 11th, 2005 06:44 PM


All times are GMT +1. The time now is 03:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.