Search results

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... :)

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... :confused:

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...

Bingo... Thank you, Thank you, Thank you... I really appreciate it... :) Jim

Could somebody please tell me what is the problem with my query? I'm getting a type mismatch error and I can't find what's the problem... In my query, I have Patient_ID, Psych_visit, & Diag_Code (see table,query & module below). Many thanks.... ---TABLES--- Diag_Med_TBL Patient_ID (text)...