DSum with two criteria

[Fireman1143]

I am trying to write a DSum ststement to track days off for employees. I have the following:
DSum("[VSCount]","tblVacSickEmp","[VSEmpID]="& [Me].[EmplID]

My second criteria is to be >=[Me].[AnnivesaryDate] but I am having a problem adding it to the above. Suggestions?

Thanks,
Fireman1143

 

[TheAceMan1]

How are ya Fireman1143 . . .

Perhaps this:

[blue]DSum("[VSCount]","tblVacSickEmp","[VSEmpID]=" & [Me].[EmplID] & " AND [Date]>=# " & [Me].[AnnivesaryDate] & "#")[/blue]

See Ya! . . . . . .

 

[Fireman1143]

Thank you very much, TheAceMan1

I worked on the syntax for two days and you had it posted for me within 20 minutes!

The only mod I had to make was removing the [Me]. as I had that wrong in my post. Have a Happ and Safe New Year,

Fireman1143