Queries or Tables? (1 Viewer)

[jimmy0305]

I have a situation where I can't decide if I should have a report based on two queries or create a report based on multiple tables... My problem is how can I return values in my first condition even if the second condition is met, not met or null.

I tried to making a report based on two queries but it's taking a lot of time. I know there's is a simple way how to accomplish this problem. I would appreciate any suggestions and ideas...

many thanks...

here's the actual example: (Note: Patient_ID are join )

-- FIRST CONDITION --
PatientInfo_TBL
Patient_ID (text)
Last (text)
First (text)
Unit (text)

NonMD_TBL
Patient_ID (text)
Treat-Date (Date)
Modality_Code (text)-cbo
Psychologist (text)-cbo

-- SECOND CONDITION --
DiagMed_TBL (Dx_ID & Mx_ID are join)
Patient_ID (text)
Dx_ID (autoNum)
Mx_ID (Numeric)--> using GenUniqueID()
Psych-visit (date)

Diag_detail_TBL
Diag_ID (autoNum)
Dx_ID (Numeric)
Diag_Code (text)-cbo

Meds_detail_TBL
Meds_ID (autoNum)
Mx_ID(Numeric)
Meds_Code (text)-cbo


In my Query I have :

fieldname : Patient_ID, Unit, Last, First,Treat-Date, Modality_Code, Psychologist, Diag_Code, Meds_Code
Total : All Grouped by except for Treat-Date [Last]
Criteria : Month([Treat_Date]) & [Enter Psycologist]

 

[Len Boorman]

Have you considered

Query 1 consisting of first condition with a left join to Query 2 which is the second condition.

Thus all records from Query 1 and only those from query 2 that match on the Joining Field

Len B

 

[jimmy0305]

Could you please give me specific details? I'm still learning access so to speak... Actually, I tried joining the tables but I still can't figure out how can I return all second condition values even if its all null. My primary concern is the first condition. Thanks...

 

[Len Boorman]

Join either the tables or queries.

Then highlight the actual link line, right click and you can select join properties. If you read these properties you will see exactly what I mean

len

 

[jimmy0305]

Bingo... you're right.
But I still have a problem... Some still shows all the Diag_Code & Meds_Code... I want to filter and show only the last Diag_Code & Meds_Code if there is...

Thanks again Len...

 

[jimmy0305]

I got it... Thank you very much Len... I appreciate your help!!!

Again thanks...

Jim