Multiple DLookup Criteria

[Levans digital]

bfLeaveDue = DSum("[LeaveDue]", "qryVacation", "VacationID <= " &
[VacationID] )

The above expression works as it supposed to but the I would like to narrow
down the results by adding in a second criteria. thats looks like this.

bfLeaveDue = DSum("[LeaveDue]", "qryVacation", "EmploymentID = " &
[EmploymentID] )

How can I join these togather? I have tried several ways, honestly I dont
know if its even possible.

Basically the completed expression should sum the value of the "leaveDue"
field based on all the "vacationID" that is less than or equal to the current
"vacationID" for the current "EmployeeID. Initially the "bfLeaveDue" will be
populated on the click of a button.

Thanks

 

[Kevin B]

Perhaps the following will work for you:

=DSum("[LeaveDue]","qryVacation","[EmploymentID]= " & [EmploymentID] & " And
[VactionID]<=" & [VactionID])

 

[Levans digital]

Thanks for the reply.
However when the expression is run on the click event of a button on the
form I get "Microsoft access cannot find the field "!"........

What do you think

Perhaps the following will work for you:

=DSum("[LeaveDue]","qryVacation","[EmploymentID]= " & [EmploymentID] & " And
[VactionID]<=" & [VactionID])
--
Kevin Backmann

bfLeaveDue = DSum("[LeaveDue]", "qryVacation", "VacationID <= " &
[VacationID] )

The above expression works as it supposed to but the I would like to narrow
down the results by adding in a second criteria. thats looks like this.

bfLeaveDue = DSum("[LeaveDue]", "qryVacation", "EmploymentID = " &
[EmploymentID] )

How can I join these togather? I have tried several ways, honestly I dont
know if its even possible.

Basically the completed expression should sum the value of the "leaveDue"
field based on all the "vacationID" that is less than or equal to the current
"vacationID" for the current "EmployeeID. Initially the "bfLeaveDue" will be
populated on the click of a button.

Thanks