By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,140 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,140 IT Pros & Developers. It's quick & easy.

Sum lost day type by active employee

P: 200
I've attached a screenshot to help explain what I need. If it is difficult to see the details, a larger file is located here:

The Date History form (shown with a green #1) is where the user enters data. The summary data is visible in Date History subform (green #2). These data are stored in the Date History table shown at the bottom.

I would like Lost time days and Restricted work days to automatically total (shown with the red numbers 5 & 10).

This group is most helpful. Thanks for looking at this post.
Attached Images
File Type: jpg LTDays2.jpg (15.3 KB, 100 views)
Feb 6 '09 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,287
I can't quite make out the picture, but I think what you want to do is put code in the OnCurrent event of the main form. Set each textbox using the DSum function.
Feb 6 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.