unusual linking question?

[russi]

Hi.
I have a table with contract numbers and acceptable start date and end date for training.
And I have a different table which has records for individuals with fields which include a contract one that is a combination of a vendor name and the contract number, plus the individual's training start date.

Anyway, I need to run a query which would check to verify that the individual's start date falls within that contract's acceptable start range.

How would I link the 2 tables? There really isn't a 'firm' related field. Or, is this impossible.

Russ

 

[Kinger43]

Add both tables to your query and don't join them. Add the desired fields from both tables and then make a field that pulls the contract number from the vender/contract number field in the second table. In the criteria of this field set it equal to the contract number field of the first table. Then you can put something like "Not Between Table1.startdate and Table1.enddate" in the criteria of the individuals start training date and this will pull the records where the individuals start training date does not fall within the acceptable contract start training period.