Here is the gist of the problem.

I am creating a database which tracks Continuing Education Credits for a large number of independent contractors who are sourced out to companies by our a staffing company. These contractors can be full time for a single company or part time for up to 4 different companies. All companies require a certain number of training hours per year, so someone who works for company x & company y can use the continuing education credits to satisfy both companies. Each individual company requests periodic reports which list the contractors training hours. Each contractor should not know that individual contractors. I am able to store and bring up the data for individual contractors by date, company, etc. but it is cumbersome because the agency requesting the report needs to be listed on the report. There are a wide number of combinations, so that it would be impossible to create individual reports for each possibility. Can any on suggest how or where I should begin. My goal is to have a VBA script in (Access 2000) that will allow me to generate a report for individual contractors based on the agency(ies) they work for. In some instances, the requesting agency could be the 2, 3rd or 4th placement on the list. I would like to be able to create the code which will 1) ask me for the name of the agency making the request, put that agencies name on the report and list all training for a specific time period. I am able to do the time, period and agency for a single report, but there are times I would also like the report to list up to 4 companies/placements on the report (if they exist). If they are blank, I want the report to close up the space. (In other words if the contractor works for one agency the report would read

Agency 1 [value]
if there were two or more agencies the report would read
Agency 1 [Value]
Agency 2 [Value]
Agency 3 [Value]
and so on.

Any suggestions on where to begin?


Brian