DSUM question

[mdgibbs88]

Hello All,

I have the following =DSUM in a box on my form:

=DSum("[NON_Value_Total]","[NON_Detail_Records]","[Employee_ID] = " & [Employee_ID])


Works great, but I want to include a parameter that only gives me results for the current year from a field named NON_Date_Proposed.


Not sure at all how to make this happen. Any help would be greatly appreciated!

 

[plog]

The last argument of the Dlookup is your criteria. So change this:

"[Employee_ID] = " & [Employee_ID]

To this:

"[Employee_ID] = " & [Employee_ID] & " AND Year(NON_Date_Proposed)=" & Year(Date())

 

[mdgibbs88]

That was perfect! Thank you much plog!