totals based on specific data

[helpmeplease]

We are required to track that each employee has a minimum of 12 hours of
training per year. I have a report based on a query that selects active
employee training data during a certain time period entered by a user and if
it is a mandatory training the date does not matter. I want to total the
"contact hours" if the completion date is bewteen the user entered date
range. IE I would type 1/1/08 to 12/31/08 - the report would show all
training during that time and any mandatory trainings that may be outside
that period. I only want to add the hours inside that time.

 

[Jeff Boyce]

"How" depends on "what" ... and you haven't described what data/table
structure you are working with...

More info, please...

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

 

[helpmeplease]

I have an employee table with an ID, name, etc. I also have a training table
that holds the ID, training, date, etc. They are linked through the ID. My
query is set up to pull all training for active employees between the user's
date range OR all mandatory training for an active employee.

 

[Jeff Boyce]

I don't understand...

The ID field in the employee table points to the employee. The ID field in
the training table points to the training.

You need a third table to connect the two. That third table would have a
field each for the EmployeeID and the TrainingID.

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

 

[helpmeplease]

Actually both tables have the employee ID in a one-to-many relationship.

 

[Jeff Boyce]

Then where do you store the training records? Remember, we aren't there...
we can't see your database... You need to give us enough information to go
on...

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