Sum subcategories can't be greater than total

[Becky Lazar]

Hi,

I have a form that has a field totalhrs. There are 7 subcategories that can be less than or equal to the totalhrs field. How can I add up the subcategoreis and then check to see if it is less than or equal to the totalhrs field?

Thanks
Becky

 

[Roger Carlson]

If the subcategories are stored in a subform, take a look at my website
(www.rogersaccesslibrary.com) for a sample called "SubformReference.mdb" In
it you will find a subform that sums the values in the subform and how to
reference that sum from the main form.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Hi,

I have a form that has a field totalhrs. There are 7 subcategories that

can be less than or equal to the totalhrs field. How can I add up the
subcategoreis and then check to see if it is less than or equal to the
totalhrs field?