Please help me out with union query

[radicrains]

"Pic1" - Owner Query for drawings going to overdue in 14 days
"Pic2" - Class Query for drawings going to due in 14 days
"Pic3" - Production Query for drawings going to due in 14 days

So basically i have 3 queries...


I need to create a report that has all 3 results.. Please refer to "Report Pic" for the end product that i need to have...

Correct me if I'm wrong, but i think i need to use union query to compile the results together. But the thing is, I am very new to Microsoft Access and I'm doing this project for my internship.. So please help me out on hte code or better ways for me to get the end product..

Please refer to "Query Pic" to understand how I've queried for "Pic1","Pic2" and "Pic3"..

Thanks...

[ajetrumpet]

radicrains,

Pls don't start a million different threads for each issue that you run into WHILE you're working it. The forum database is pretty big, but that is not welcome behavior. It also doesn't make you look very sincere about wanting help. Try what you have and then post if a real issue comes up that you can't solve yourself after an hour of working on it.

as far as this thread goes, which is a continuation of the one about repeating records and the first one about helping you 2 hours ago...

you can use "SELECT DISTINCTROW" to begin your query statement if your sql involves pulling data from more than one table. It does not filter out duplicate records using one table only.