Query Help

[TRYP]

I need to get a list of account names from a table whose contracts have expired on a certain Date.

I also need to ensure that then do not have an overlapping contract that ends on a future date.

FIELDS AVAILABLE:
[Account Name]
[contract end date]
[contract start date]

I have been at this for HOURS!!!!
Help if you can PLEASE !!!!!

TRYP

 

[JoeMiller]

From the little information provided I would venture to guess you need three seperate queries.

Query 1
This query will return the expired contracts

Query 2
This query will return the future contracts

Query 3
This query compares 1 and 2 and looks for people who have a value in 1 but no value in 2. The Access Query Wizard calls this an "Unmatching Query"


HTH
Joe Miller
joe.miller@flotech.net