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

Total by option group

P: 200
I have a table like below as a sub-form:

Start Date Return Date Type of Lost Days Total
12/17/2008 12/25/2008 Lost Time Days 8
1/1/2009 2/4/2009 Lost Time Days 34
10/7/2008 10/15/2008 Resticted Days 8
12/2/2008 12/17/2008 Resticted Days 15
12/26/2008 12/30/2008 Resticted Days 4

These are data for a single employee. As the case progresses, there may be additional lost and/or restricted days. How can I keep a running total in a text box for the type of lost days? In other words, this total would not run as a query, but would total when new data was added to another sub-form appearing on the same main form.

Any info. is appreciated.
Feb 5 '09 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,287
You can set one textbox to

=DSum("Total", "TableName", "[Type of Lost Days] = ""Lost Time""")

and the other one to

=DSum("Total", "TableName", "[Type of Lost Days] = ""Restricted""")

You may have to .Requery the text box when the subform is updated.
Feb 5 '09 #2

Post your reply

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