|
| 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
November 22nd, 2005, 07:18 PM
posted to microsoft.public.access.reports
|
|||
|
|||
problem with dsum
I need help...in my report I am trying to get the total of accidents that
happen in a department. For example I have 43 department in my report I need to show that the Road Department has 3 accidents....how can this be done. Thanks -- LHEMA 
|
|
#2
November 22nd, 2005, 08:51 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
problem with dsum
Group by Department and add a text box in the group footer (or header):
=Count(*) -- Duane Hookom MS Access MVP -- "LHEMA" wrote in message ... I need help...in my report I am trying to get the total of accidents that happen in a department. For example I have 43 department in my report I need to show that the Road Department has 3 accidents....how can this be done. Thanks -- LHEMA
|
|
#3
November 22nd, 2005, 09:06 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
problem with dsum
It works, thank you
LHEMA "Duane Hookom" wrote: Group by Department and add a text box in the group footer (or header): =Count(*) -- Duane Hookom MS Access MVP -- "LHEMA" wrote in message ... I need help...in my report I am trying to get the total of accidents that happen in a department. For example I have 43 department in my report I need to show that the Road Department has 3 accidents....how can this be done. Thanks -- LHEMA
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Out of office assistant problem | Jeremiah | General Discussion | 9 | October 14th, 2008 02:21 PM |
| IE6 & Outlook Problem (Strange Problem)! | KW | Outlook Express | 4 | February 1st, 2005 08:31 AM |
| Reinstalling OE... | KAR | Outlook Express | 24 | August 21st, 2004 06:52 PM |
| Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
| word error | mac | General Discussions | 1 | May 6th, 2004 08:14 AM |
Linear Mode
