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 |
#11
|
|||
|
|||
I'm stuck can not get total sum correct
Did you place the new text boxes in a group or report footer section? I
can't imagine you would want them to appear anywhere else except maybe a header section. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... 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 |
#12
|
|||
|
|||
I'm stuck can not get total sum correct
Good morning, Duane
They are in a report footer and the employee total does work. I think I told you it did not work. The dept total des not work, I have tried this expression but it does not give me the numeric it gives me the name of the deparment name: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) and using this expression it shows and error in employee total but ehn I take that expression out employee total works -- LHEMA "Duane Hookom" wrote: Did you place the new text boxes in a group or report footer section? I can't imagine you would want them to appear anywhere else except maybe a header section. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... 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 |
#13
|
|||
|
|||
I'm stuck can not get total sum correct
I'm not sure what you want where at the moment. Your expression:
=nz(DLookUp("Department=1","[qry Employee Accident]"),0) shouldn't result in anything useable. Where is this expression and what are you attempting to calculate. If [qry Employee Accident] has more than one record, who knows which value it might return. Normally the first argument in DLookup() is not a true/false type expression. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... Good morning, Duane They are in a report footer and the employee total does work. I think I told you it did not work. The dept total des not work, I have tried this expression but it does not give me the numeric it gives me the name of the deparment name: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) and using this expression it shows and error in employee total but ehn I take that expression out employee total works -- LHEMA "Duane Hookom" wrote: Did you place the new text boxes in a group or report footer section? I can't imagine you would want them to appear anywhere else except maybe a header section. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... 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 |
#14
|
|||
|
|||
I'm stuck can not get total sum correct
What I want is to total each department separately...right now employee total
is working great using the expression =count([employeeID]) but how can I get the department to do the same. Using this expression =count([department]) does not count them separately it count them together. Now if I have a employee that has to accident it counts that correctly but I have other employees in that department that had an accident and I need to total them together. I hope I am making since. -- LHEMA "Duane Hookom" wrote: I'm not sure what you want where at the moment. Your expression: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) shouldn't result in anything useable. Where is this expression and what are you attempting to calculate. If [qry Employee Accident] has more than one record, who knows which value it might return. Normally the first argument in DLookup() is not a true/false type expression. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... Good morning, Duane They are in a report footer and the employee total does work. I think I told you it did not work. The dept total des not work, I have tried this expression but it does not give me the numeric it gives me the name of the deparment name: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) and using this expression it shows and error in employee total but ehn I take that expression out employee total works -- LHEMA "Duane Hookom" wrote: Did you place the new text boxes in a group or report footer section? I can't imagine you would want them to appear anywhere else except maybe a header section. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... 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 |
#15
|
|||
|
|||
I'm stuck can not get total sum correct
I don't see any sample records or how you would want to display these with
your calculated totals in your report. Could you take the time to manually type a few records into a reply so that we can "see" what you want rather than attempting to understand your description. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... What I want is to total each department separately...right now employee total is working great using the expression =count([employeeID]) but how can I get the department to do the same. Using this expression =count([department]) does not count them separately it count them together. Now if I have a employee that has to accident it counts that correctly but I have other employees in that department that had an accident and I need to total them together. I hope I am making since. -- LHEMA "Duane Hookom" wrote: I'm not sure what you want where at the moment. Your expression: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) shouldn't result in anything useable. Where is this expression and what are you attempting to calculate. If [qry Employee Accident] has more than one record, who knows which value it might return. Normally the first argument in DLookup() is not a true/false type expression. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... Good morning, Duane They are in a report footer and the employee total does work. I think I told you it did not work. The dept total des not work, I have tried this expression but it does not give me the numeric it gives me the name of the deparment name: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) and using this expression it shows and error in employee total but ehn I take that expression out employee total works -- LHEMA "Duane Hookom" wrote: Did you place the new text boxes in a group or report footer section? I can't imagine you would want them to appear anywhere else except maybe a header section. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... 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 |
#16
|
|||
|
|||
I'm stuck can not get total sum correct
LHEMA wrote:
What I want is to total each department separately...right now employee total is working great using the expression =count([employeeID]) but how can I get the department to do the same. Using this expression =count([department]) does not count them separately it count them together. Now if I have a employee that has to accident it counts that correctly but I have other employees in that department that had an accident and I need to total them together. I hope I am making since. I'm not sure what you want where at the moment. Your expression: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) [quoted text clipped - 72 lines] Any help is appreciation. To count the by Department, you need to add a Group Footer for Department and put "Count([Department]) into the new textbox. By Grouping with this Footer, you can input your textbox to count. Text1: =Count(Department]) Text2: =Count([EmployeeID]) The "=nz(DLookUp("Department=1","[qry Employee Accident]"),0)" does not do any counting, all it does is to look up for a value. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200604/1 |
#17
|
|||
|
|||
I'm stuck can not get total sum correct
I have =count([department]) and =count([employeeID]) in the footer but its
not returning the correct results for department. What I need is to count each department separtely and what I mean is that frank has 2 accident in the road dept. John has 1 so the total should be three. Hope this helps -- LHEMA "AccessVandal via AccessMonster.com" wrote: LHEMA wrote: What I want is to total each department separately...right now employee total is working great using the expression =count([employeeID]) but how can I get the department to do the same. Using this expression =count([department]) does not count them separately it count them together. Now if I have a employee that has to accident it counts that correctly but I have other employees in that department that had an accident and I need to total them together. I hope I am making since. I'm not sure what you want where at the moment. Your expression: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) [quoted text clipped - 72 lines] Any help is appreciation. To count the by Department, you need to add a Group Footer for Department and put "Count([Department]) into the new textbox. By Grouping with this Footer, you can input your textbox to count. Text1: =Count(Department]) Text2: =Count([EmployeeID]) The "=nz(DLookUp("Department=1","[qry Employee Accident]"),0)" does not do any counting, all it does is to look up for a value. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200604/1 |
#18
|
|||
|
|||
I'm stuck can not get total sum correct
What sample are you looking for I have tried =count([Department]),
=Sum(IIf([Department]="1",[EmployeeID],0)) =IIf(Count([Department]) =0)) =Sum(IIf([department]= "42200",1,0) =Sum(nz([Department])) For all these attempts I get and error in returned. LHEMA "Duane Hookom" wrote: I don't see any sample records or how you would want to display these with your calculated totals in your report. Could you take the time to manually type a few records into a reply so that we can "see" what you want rather than attempting to understand your description. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... What I want is to total each department separately...right now employee total is working great using the expression =count([employeeID]) but how can I get the department to do the same. Using this expression =count([department]) does not count them separately it count them together. Now if I have a employee that has to accident it counts that correctly but I have other employees in that department that had an accident and I need to total them together. I hope I am making since. -- LHEMA "Duane Hookom" wrote: I'm not sure what you want where at the moment. Your expression: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) shouldn't result in anything useable. Where is this expression and what are you attempting to calculate. If [qry Employee Accident] has more than one record, who knows which value it might return. Normally the first argument in DLookup() is not a true/false type expression. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... Good morning, Duane They are in a report footer and the employee total does work. I think I told you it did not work. The dept total des not work, I have tried this expression but it does not give me the numeric it gives me the name of the deparment name: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) and using this expression it shows and error in employee total but ehn I take that expression out employee total works -- LHEMA "Duane Hookom" wrote: Did you place the new text boxes in a group or report footer section? I can't imagine you would want them to appear anywhere else except maybe a header section. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... 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 |
#19
|
|||
|
|||
I'm stuck can not get total sum correct
Recently I have asked posters to "manually type a few records into a reply".
I'm not sure what it is about this request but it seems very difficult for the OP to comply. This thread is nearly 20 posts in length and I believe could be satisfactorily completed if you would provide enough fields and records with your desired calculations to thoroughly describe your needs. I kinda expect that you want to maybe count unique values. I don't think you have even stated anything like "I get a count value of 8 when I only have 2 departments". -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... What sample are you looking for I have tried =count([Department]), =Sum(IIf([Department]="1",[EmployeeID],0)) =IIf(Count([Department]) =0)) =Sum(IIf([department]= "42200",1,0) =Sum(nz([Department])) For all these attempts I get and error in returned. LHEMA "Duane Hookom" wrote: I don't see any sample records or how you would want to display these with your calculated totals in your report. Could you take the time to manually type a few records into a reply so that we can "see" what you want rather than attempting to understand your description. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... What I want is to total each department separately...right now employee total is working great using the expression =count([employeeID]) but how can I get the department to do the same. Using this expression =count([department]) does not count them separately it count them together. Now if I have a employee that has to accident it counts that correctly but I have other employees in that department that had an accident and I need to total them together. I hope I am making since. -- LHEMA "Duane Hookom" wrote: I'm not sure what you want where at the moment. Your expression: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) shouldn't result in anything useable. Where is this expression and what are you attempting to calculate. If [qry Employee Accident] has more than one record, who knows which value it might return. Normally the first argument in DLookup() is not a true/false type expression. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... Good morning, Duane They are in a report footer and the employee total does work. I think I told you it did not work. The dept total des not work, I have tried this expression but it does not give me the numeric it gives me the name of the deparment name: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) and using this expression it shows and error in employee total but ehn I take that expression out employee total works -- LHEMA "Duane Hookom" wrote: Did you place the new text boxes in a group or report footer section? I can't imagine you would want them to appear anywhere else except maybe a header section. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... 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 |
#20
|
|||
|
|||
I'm stuck can not get total sum correct
Sorry for your frustration but maybe I am not being clear, here is another
example Department Employee Employee Total Dept Total 42200-Road Frank 2 2 33000- Sheriff Orrin 1 1 33260- County Jail Ken 3 3 42200- Road Steve 1 3 33000-Sheriff Jeff 1 2 33260-County Jail Alan 3 6 I hope that helps -- LHEMA "Duane Hookom" wrote: Recently I have asked posters to "manually type a few records into a reply". I'm not sure what it is about this request but it seems very difficult for the OP to comply. This thread is nearly 20 posts in length and I believe could be satisfactorily completed if you would provide enough fields and records with your desired calculations to thoroughly describe your needs. I kinda expect that you want to maybe count unique values. I don't think you have even stated anything like "I get a count value of 8 when I only have 2 departments". -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... What sample are you looking for I have tried =count([Department]), =Sum(IIf([Department]="1",[EmployeeID],0)) =IIf(Count([Department]) =0)) =Sum(IIf([department]= "42200",1,0) =Sum(nz([Department])) For all these attempts I get and error in returned. LHEMA "Duane Hookom" wrote: I don't see any sample records or how you would want to display these with your calculated totals in your report. Could you take the time to manually type a few records into a reply so that we can "see" what you want rather than attempting to understand your description. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... What I want is to total each department separately...right now employee total is working great using the expression =count([employeeID]) but how can I get the department to do the same. Using this expression =count([department]) does not count them separately it count them together. Now if I have a employee that has to accident it counts that correctly but I have other employees in that department that had an accident and I need to total them together. I hope I am making since. -- LHEMA "Duane Hookom" wrote: I'm not sure what you want where at the moment. Your expression: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) shouldn't result in anything useable. Where is this expression and what are you attempting to calculate. If [qry Employee Accident] has more than one record, who knows which value it might return. Normally the first argument in DLookup() is not a true/false type expression. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... Good morning, Duane They are in a report footer and the employee total does work. I think I told you it did not work. The dept total des not work, I have tried this expression but it does not give me the numeric it gives me the name of the deparment name: =nz(DLookUp("Department=1","[qry Employee Accident]"),0) and using this expression it shows and error in employee total but ehn I take that expression out employee total works -- LHEMA "Duane Hookom" wrote: Did you place the new text boxes in a group or report footer section? I can't imagine you would want them to appear anywhere else except maybe a header section. -- Duane Hookom MS Access MVP "LHEMA" wrote in message ... 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 |