Adding to existing code (Clarification of earlier post)

[judyb]

After rereading my earlier post, I find that I wasn't very
clear. I'll try again. My existing code works to give me the sum of all
Weeks Service where the Department Name is equal to the Current Department
Name and I do want to keep that code. In addition to that code though, I
need to add, I'm guessing, an "IF Statement" that will provide me with the
sum of ALL Weeks Service of ALL Department Name IF the Current Department
Name is equal to "Reserves".

Example:
Department Name Weeks Service
Millwright 35 weeks
Pipefitter 10 weeks
Millwright (Current Deptment Name) 3 weeks

The existing code adds all the Weeks Service where the Department Name is
equal to the Current Department Name (Millwright) for a total of 38.

In the same example, if the Current Department Name were "Reserves", I need
code that will add ALL of the Weeks Service of ALL Department Name to give me
a
total of 48.

I hope this makes more sense. In short, I need to keep the existing code,
but need it to sum the Weeks Service slightly different IF the Current
Department Name is equal to "Reserves". Thanks in advance!

 

[judyb]

I can't seem to get it all together. I left off my existing code in the
previous post. That code is:

=DSum("[WeeksService]","Service Record Query","[EmployeeID] = " &
[EmployeeID] & " And [DepartmentName] = Current_Department_Name")

Thanks for any help!

 

[De Jager]

After rereading my earlier post, I find that I wasn't very
clear. I'll try again. My existing code works to give me the sum of all
Weeks Service where the Department Name is equal to the Current Department
Name and I do want to keep that code. In addition to that code though, I
need to add, I'm guessing, an "IF Statement" that will provide me with the
sum of ALL Weeks Service of ALL Department Name IF the Current Department
Name is equal to "Reserves".

Example:
Department Name Weeks Service
Millwright 35 weeks
Pipefitter 10 weeks
Millwright (Current Deptment Name) 3 weeks

The existing code adds all the Weeks Service where the Department Name is
equal to the Current Department Name (Millwright) for a total of 38.

In the same example, if the Current Department Name were "Reserves", I
need
code that will add ALL of the Weeks Service of ALL Department Name to give
me
a
total of 48.

I hope this makes more sense. In short, I need to keep the existing code,
but need it to sum the Weeks Service slightly different IF the Current
Department Name is equal to "Reserves". Thanks in advance!