Totals Query Help

[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.

 

[Lord Kelvan]

nothings wrong it is what access does it should do the same thing

does your query work would be the better question

 

[Maarkr]

Pls post the whole query...does the function work if you have only the ONE
field in the query with no other fields?