All process welded dates

[The Big Bear]

Hi all

My company has 20 welders that use 5 different welding processes. We are required to keep a log on which welding process is being use by each welder per month.

What I have a continunity log that shows the first day that the welder was tested and the last day that the welder welded using that welding process. I would like to print a report that would show all the dates that each welder used each welding process. I would like the report to be something like shown below

Example:

• name GTAW GMAW FCAW
  

• Mark 2/11/2012 2/11/2012
  

1. 3/14/2012 3/14/2012
   

• 4/12/2012 4/12/2012 4/15/2012
  

• John 1/12/2012
  

1. 2/12/3012
   

• 3/24/2012 3/11/2012 3/14/2012
  

Hope this helps.

Any ideas would be helpful and appreicated.

Lionel

[Vaughan]

"show all the dates that each welder used each welding process"

So you need to record each time a welder used the welding process. Each time.

From this information you can calculate lots of other things.

[The Big Bear]

Vaughan

A need to record each date that the welder use that process.

and would like it to print each date under the process use . Print one page for each welder.

Lionel

[Vaughan]

Vaughan

A need to record each date that the welder use that process.

and would like it to print each date under the process use . Print one page for each welder.

Lionel

Ok, the first step is to record the date each welder used the process. This should be done in a separate record for each instance a welder used a process. I'd make a table of welders and another of processes to avoid data errors.

Welder --> Log <-- WeldingProcess

From this you could generate the necessary reports by date, process, etc.

[The Big Bear]

Thanks