Totals Query Help

  • Thread starter Thread starter JudyB
  • Start date Start date
J

JudyB

I have a query with the following fields:

EmployeeID
DepartmentName
WeeksService: (CalcWeeks([DateStart],[DateEnd]))

I am trying to sum the total weeks that an employee has worked in each
Department. Example: An employee works 52 weeks in Sales, 52 weeks in
Purchasing, and then goes back to Sales where he is currently working and has
been there for 105 weeks. I want the Sales Department to show this employee
with 157 weeks and the Purchasing Department to show 52 weeks.

When I try to use Sum in the Totals Row under
WeeksService: (CalcWeeks([DateStart],[DateEnd])) the system changes the
field to: WeeksService: Sum(CalcWeeks([DateStart],[DateEnd])) and puts
"Expression" in the Totals row.

What am I doing wrong? Can you not Sum a field that uses a function? Any
help would be greatly appreciated.
 
nothings wrong it is what access does it should do the same thing

does your query work would be the better question
 
Pls post the whole query...does the function work if you have only the ONE
field in the query with no other fields?
 
Back
Top