Need to use the DSUM function to calculate the total number of vacation days
remaining. Please help, I have been stumped for 2 days now.

Leave Summary

Vacation Leave Number Eligible Total Days Days Remaining
17-day 36 612
12-day 29 348
7-day 6 42
none 31 0
Total 102 1002

the database is:

Name Status Yrs Employed Vacation Leave Used Vacation Leave Remaining
Vacation Leave
Abba FT 0.1 7 5 2
Abbot FT 4.0 12 7 5
Adtkins FT 5.7 17 4 13
Andrews FT 8.8 17 3 14
Baker PT 2.5 0 0 0
Berg FT 4.5 12 4 8
Bergeman FT 10.0 17 4 13
Blake CN 0.3 0 0 0



Please help.

--
DLLewis