Need to pull query for 2 Status with recent and prior dates

[undefatedskillz26]

Hi everyone,

First time posting here so wanted to say hello to everyone.

[June7]

One way to find 'most recent' is with a TOP N parameter nested query. Review http://allenbrowne.com/subquery-01.html#TopN

However, your additional criteria makes this much more complicated.

[undefatedskillz26]

Do you think this would work if it was coded maybe in VBA? There has to be a way for this to work, just dont know which route to go.

[JeffChr]

I don't understand the dates and the 4-day spread. All of the dates you show have more than 4-days in between. One date is the most recent and the second date is the one prior, (filtered by P01), but only if it is within 4-days; is the way I interpreted your criteria.

[undefatedskillz26]

Okay I am trying to make this simpler since I am getting deperate here to come up with an answer.

I need the query to have 2 status for each patient. If both status are the same for each Patient record ID, and is more than 3 business days apart, than I should see it in the query. Is this easier to do?

[JeffChr]

No actually that doesn't make it easier. It was a lot easier if the query could just be filtered to P01. OK, so more than 3-days apart. Fine. Post about the P01 filter - firm up our intent with that criteria perhaps an answer will be at hand.

[undefatedskillz26]

Okay i created a duplicate Query to find duplicated within the same recordID and Status. It seems to work for now. May have a question on the business days beging greater than 3 days, will do some research. Thank you very much for your time and efforts.

[undefatedskillz26]

Closing thread, thanks everyone.