|
| 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
April 18th, 2006, 08:17 PM
posted to microsoft.public.access.reports
|
|||
|
|||
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 
|
| 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 |
Threaded Mode