Hi Tony,
I have two fields in one table, one is called "Date Job Raised" and the other is "Date Job Finished". The amount of jobs raised by the 1/5/07 was 2000. The amount of jobs finished by 1/5/07 was 1800. This means that there are 200 jobs which had not be finished by the 1/5/07. Those 200 jobs were outstanding on the 1/5/07. However they had been completed since then, so the finish date is no longer blank but populated with dates >1/5/07. I would like to create a query that can return those 200 jobs. It needs to return all jobs where "Date Job Raised" <1/5/07 minus all jobs where "Date Job Finished" is < 1/5/07.
Have you got an idea, how to do that? I think it might be fairly simple.
Thank you,
Peter.