Access Need help with Simple HR Form in Access 2007

[JFMacd]

Hi, I am creating a simple form to calculate total vacation days allotted (all positive numbers), total vacation days used (all negative numbers), and then a total for vacation days left.

This form is linked to a query which has the following fields: Days, FullName, Description, EmpID, RequestComments, Hours.

I used the following formula's to calculate the above:

=DSum("[Days]","qryAbsences","[Days]>=1")
=DSum("[Days]","qryAbsences","[Days]<0")
=DSum("[Days]","qryAbsences")

But this will total the Days in the entire query, how do I get it to calculate for only one Employee at a time? I had a parameter set on the query for fullname but the formula's don't work with the parameter.

Thanks!