Date Problem

[Kyriakos]

Hi to everyone. I have this really complex query with numerous criteria on and I came upon this. The query (among other things) displays results from a test that was performed after a certain date (e.g. 31/12/2004). The query was displaying ok results until now but, I was told to not only get those results from the people who match those criteria (which is fine) but to search and include in the query, for those people only, previous dates of tests that were performed after the 30/4/2004....

I tried just >30/4/2004, i tried >30/4/2004 AND > 31/12/2004 in the criteria section but this as a result includes also records from people who only performed tests before the 31/12/2004.I need people who performed tests both after the 31/12/2004 and before that... ....Any clues?

I'm not quite sure if I made myseef clear....

Any help is wanted though....Thanx...

 

[Jon K]

You can do it with a serial of two queries. See example in the attachment.

The first query gets the IDs of people tested since 2005.
The second query retrieves their records since May 2004.

Run the second query.
.

 

[Kyriakos]

Thanx Jon, that really worked. I thought, prior to testing that, that this would mean extra time to run the final query. In the end it is just a couple of seconds difference, so it's ok...

Thanx once again.