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.Status FROM EMPStatus, Attendance
WHERE (((Attendance.Date)=Forms!Attendance.Date2) And ((EMPStatus.Process)=Forms!Attendance.SelectProces s) And ((Attendance.EmpID)=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.Status FROM EMPStatus, Attendance
WHERE (((Attendance.Date)=Forms!Attendance.Date2) And ((EMPStatus.Process)=Forms!Attendance.SelectProces s) And ((Attendance.EmpID)=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.