How to merge to two queries and display it as each colums

[Rajesshram]

I have two table designed in Access, I have two queries to populate data. I used the UNION option to merge the queries but I need the result as colums and not row wise. Any Idea how i should proceed...
The below query is working for two colums but If i need more than 2 with specific condition for each how do i do that... Please help

SELECT EMPStatus.EmpID , Attendance.Stat us FROM EMPStatus, Attendance
WHERE (((Attendance.D ate)=Forms!Atte ndance.Date2) And ((EMPStatus.Pro cess)=Forms!Att endance.SelectP rocess) And ((Attendance.Em pID)=EMPStatus. EmpID));

[PianoMan64]

I have two table designed in Access, I have two queries to populate data. I used the UNION option to merge the queries but I need the result as colums and not row wise. Any Idea how i should proceed...
The below query is working for two colums but If i need more than 2 with specific condition for each how do i do that... Please help

SELECT EMPStatus.EmpID , Attendance.Stat us FROM EMPStatus, Attendance
WHERE (((Attendance.D ate)=Forms!Atte ndance.Date2) And ((EMPStatus.Pro cess)=Forms!Att endance.SelectP rocess) And ((Attendance.Em pID)=EMPStatus. EmpID));

Can you give a visual example of what it is that you want to see, and also include sample data that is in the EMPStatus Table as well as the Attendance Table?

Thanks,

Joe P.