totals based on specific data

  • Thread starter Thread starter helpmeplease
  • Start date Start date
H

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.
 
"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.
 
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.
 
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.
 
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.
 
Back
Top