Recent content by Unas_

THANK YOU THANK YOU THANK YOU!!!!!!!!! You're a genius!

No, I do want to return mrn's if there is only one record (basically the newest MixedDate (minus the 90days) Your second question is correct. The Newest MixedDate should be returned. There is one more caveat, if there is a date in the PostCardSentDate then do not display those results but...

Yes this is can all be done in one query. And yes the above is correct.

Yes and No, basically everytime we run the query we want to first exclude any request (with a older MixedDate) with the same MRN from the list and then exclude all requests from the last 90 days. Does that make sense? The above is an example of the first list and then we would like to filter...

Here are some examples: MRN MixedDate Today=31/3/13 - 90 days ago=1/1/13 1 1/1/12 exclude 1 1/2/13 include 2 1/3/12 exclude 2 1/11/12 include 3 02/20/13 include 3 02/19/13 exlcude 3 01/19/13...

Hello, thanks again for your help but let me clarify what I am needing (and again, thank you for the help!). I am needing a list of all my "Requests" but with the following criteria applied: 1. I need the entire list but only the ones that have a "MixedDate" of 90 days or older. 2. I am also...

You are correct. The MRN value is the primary key in PatientData table and cannot be null.

Hello, I got it to work and it displays duplicate MRN's next to each other but how do I limit the list by removing the oldest if there is a duplicate and then displaying the last 90 days? Here is my SQL criteria This is under the MRN 'Or' heading: In (SELECT [MRN] FROM [PostCardSent] As Tmp...

Hey, sorry I tried it several times and finally got it to accept it but it pops up with a text box asking for the MRN number. Any clues?

Hello, I tried this and it has given me a syntax error. Could you assist? I have find duplicates query with the following fields (MRN, Patient_Last_Name, Patient_First_Name, PhoneNumber, StreetAddress, City, State, ZipCode, MixedDate, PostCardSentDate). Thank you.

Hello, I have a little bit of experience in Access (i've built a few production databases) but I am having an issue that I cannot resolve. Here it goes.... I have a query that contains all transactions for a service. I am needing to filter this by first seeing if there are duplicate IDNumbers...