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!
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!