Sum subcategories can't be greater than total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Becky Lazar said:
Hi,

I have a form that has a field totalhrs. There are 7 subcategories that
Click to expand...
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?
 
Back
Top