How do I create single report using multiple queries with some of the same IDs?

[IrogSinta]

There's something else going on in your database that I'm not seeing here. Can you make a copy of your database but only include a small sampling in the tables along with the queries you use. Just make sure there is no private data included such as peoples names.

Ron

[jjz0512]

I still haven;t been able to creation this report, but I would also need help on how the query is developed in generating the criteria for the selecting dates. I use this as criteria; >=#7/25/2015 12:00:00 PM# And <=#7/26/2015 11:59:00 PM#. And it work fine, but need to change daily. How can i use a day before the sysdate for the first date in the criteria and sysdate for the second date, both combned with the times of the respective dates.

BTW, Here's a sample of what I'm trying to build again. The primary Query 1, that has all the MRNs. Query 2 also has all the MRN's, but can also have + or - the numbers of records found in Query 1 per MRN. Query 3 might have all MRNs, but not required and also + or - the number records found in Query 1 per MRN.

I have all the queries have unique MRN in all 3, but returning 18 records for MRN 784168942, in stead of only 3. 2 records in query 1, 3 records are found in query 2 & 3. Here's a copy of the output for all 3 queries;

MRN	Sub Location	Product Name	Unit #	Product #	Issued D/T	CXR Order D/T	CXR Image D/T
942	CT11	Red Blood Cells (Crossmatch RBC)	W084915001763	E0382V00	06/09/15 06:40	06/09/15 08:20	06/09/15 08:20
942	CT11	Red Blood Cells (Crossmatch RBC)	W084915001763	E0382V00	06/09/15 06:40	06/09/15 09:10
						06/09/15 10:03

I hope my post of these 2 issues in clear and understandable.

Thanks for all your help!

[June7]

Consider:

Between Date()-1+#12:00:00 PM# And Date()+#11:59:00 PM#