Calculation in a Text Box

I need help totaling combo boxes based on criteria entered in other combo
boxes.

I setup my form as follows:

A user can work on 8 different jobs in any given day. For each job their is
a corresponding Hours and Type drop down box. The Hours drop down allows
users to select from .25 to 14 hours. The Type Hours allows users to select
RG, OT, DT, OC and VA. When a job number is entered a hour selection and
type are required.

I want to total the hours at the end of each column in text boxes. One for
each type (RG, OT, DT, OC and VA). I tried several if statements but they do
not work when the same type isn't used each day.

Any help would be greatly appreciated.

Remember that the data is NOT stored in the form. The data is stored in the
underlying table.

To sum up data, sum up the data in the table. A Totals query is one way to
do this.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"OsmoseTom" wrote in message
...
I need help totaling combo boxes based on criteria entered in other combo
boxes.

I setup my form as follows:

A user can work on 8 different jobs in any given day. For each job their
is
a corresponding Hours and Type drop down box. The Hours drop down allows
users to select from .25 to 14 hours. The Type Hours allows users to
select
RG, OT, DT, OC and VA. When a job number is entered a hour selection and
type are required.

I want to total the hours at the end of each column in text boxes. One
for
each type (RG, OT, DT, OC and VA). I tried several if statements but they
do
not work when the same type isn't used each day.

Any help would be greatly appreciated.

What do you have supplying information the the text boxes in the columns and
at the bottom?

--
Build a little, test a little.


"OsmoseTom" wrote:

I need help totaling combo boxes based on criteria entered in other combo
boxes.

I setup my form as follows:

A user can work on 8 different jobs in any given day. For each job their is
a corresponding Hours and Type drop down box. The Hours drop down allows
users to select from .25 to 14 hours. The Type Hours allows users to select
RG, OT, DT, OC and VA. When a job number is entered a hour selection and
type are required.

I want to total the hours at the end of each column in text boxes. One for
each type (RG, OT, DT, OC and VA). I tried several if statements but they do
not work when the same type isn't used each day.

Any help would be greatly appreciated.