DSUM Multiple Criteria

[Falcon88]

i have a textbox in a form that must contains Dsum with Numberic and Date Criteria.

Values to sum: SumTotal
Query name: Q105
Criteria1:"[EmpID]=" & [EmpID] ( numberic )
Criteria2: " [OrderDate] <=" & [OrderDate]

How would I do this? I have been trying for a while, I would love some help

 

[Alc]

i have a textbox in a form that must contains Dsum with Numberic and Date Criteria.

Values to sum: SumTotal
Query name: Q105
Criteria1:"[EmpID]=" & [EmpID] ( numberic )
Criteria2: " [OrderDate] <=" & [OrderDate]

How would I do this? I have been trying for a while, I would love some help

= DSum("{name of field}", "{name of table}", "[EmpID] = " & [EmpID] & " AND [OrderDate] <= #" & [OrderDate] & "#")

 

[Falcon88]

ok,
but that give me some wrong results .
What about the region default settings in Windows?
if my default settings : dd/MM/yyyy