Criteria when using DSum function

[Andrew Thorpe]

Using the DSum function, the criteria section should compare a date . I have written it using inverted commas as I would for text datatypes, but it doesn't work. I've also tried using # signs. Can anyone help in amending the criteria (final) section :

TotalClaimsThisYear = DSum("NumberOfClaims", "qryRunningTotalClaims", "DateActioned > """ & Me.CompanyStartDate"""" )

A further question: can you have two criteria in one DSum function? Appreciate any help - thanks.

[meratigoerr]

TotalClaimsThisYear = DSum("NumberOfClaims", "qryRunningTotalClaims", "DateActioned > #" & Me.CompanyStartDate & "#" )

You can use more than one criteria:

TotalClaimsThisYear = DSum("NumberOfClaims", "qryRunningTotalClaims", "DateActioned > #" & Me.CompanyStartDate & "# and [SecondFieldName] = '" & me.Somerandomtextfield & "'" )