Template or Spreadsheet

[Guest]

I need a template that will list 200 volunteers for 20 different jobs.

 

[John Vinson]

I need a template that will list 200 volunteers for 20 different jobs.

This would be very simple to build as an Access database: three
tables:

Volunteers
VolunteerID
LastName
FirstName
<contact info, address, phone, email, ...>

Jobs
JobID
JobDescription
<any other info about the job, e.g. dates>

Assignments
JobID
VolunteerID
Role <if needed or appropriate>

You'll need two forms - one for Jobs, one for Volunteers with a
subform based on Assignments; and at least one Report, based on a
query joining all three tables.

This will allow you to assign tens of thousands of volunteers to tens
of thousands of jobs, if needed.

John W. Vinson[MVP]