Problem that array could fix?

[jordankoal]

I have a database that handles schedules for workers and the projects they are on

There is a personnel table which contains:
Person / project / start date / end date / duration

And there is a project table which contains:
project / client / start date / end date / duration

I have a query that populates a report to me that tells me
during a given time period (10/1/13 - 10/22/13) what personnel
are on jobs.

It gives me a list of for example
Jon Doe / Project1 / 10/2/13 / 10/20/13 / 19
Jon Doe / Project1 / 10/22/13 / 11/2/13 / 13
Jane Doe / Project 1 / 10/10/13 / 11/11/13 / 32

So when I do the report I group on Person and then hide the details section
so I get a list of everyone who is currently assigned to projects during that
time frame.

My question is, how would I go about taking that list and comparing it to
either my table of personnel (Which is different then the one with their projects, this table just has their name in it) or an array that has their names in it? I could then search through the array removing a name if it matches
a part of the array and then print out the array to give a list of who IS available instead of who ISN'T available..

I just don't know if this is possible...

Any ideas?

 

[pbaldy]

FYI, I moved your post from the moderated code repository. Have you tried the unmatched query wizard to compare the list of who is booked to the table of everybody?

 

[jordankoal]

I have not, I shall give that a try. Thank you for the response and move to proper forum

 

[pbaldy]

No problem; post back if you get stuck.

 

[jordankoal]

Worked like a charm. Thanks again. I made it way much more complicated in my head than it needed to be.

 

[pbaldy]

Happy to help!