Converting multiple records (rows) into one record (row) using a unique identifier

[spyldbrat]

I very new to using Access. I am using Access 2007. I am trying to create a Query that shows an employee's weekly scheduled on the same row. I am importing the schedules from Excel which show each employee's work date on separate rows:

Example:

EXCEL IMPORT:

EE #	EE Name	Day of Week	WorkDate	Hours	InTime	OutTime	Lunch
18264	Jane Doe	Monday	06/22/15	6	8:00	14:30	0.5
18264	Jane Doe	Tuesday	06/23/15	6	8:00	14:30	0.5
18602	Jason Thomas	Monday	06/22/15	8	16:00	23:59	0
18602	Jason Thomas	Sunday	06/21/15	8	16:00	23:59	0
17529	John Smith	Monday	06/22/15	4	17:00	21:00	0
17529	John Smith	Sunday	06/21/15	11	10:00	21:30	0.5
18509	Mary Harris	Monday	06/22/15	6	9:00	15:00	0
18509	Mary Harris	Sunday	06/21/15	6	11:00	17:00	0
18509	Mary Harris	Tuesday	06/23/15	6	11:00	17:00	0

How I need the Query to read:

EmployeeNumber	EmpName	Sunday	Sunday Date	Hours	InTime	OutTime	Lunch	Monday	Monday Date	Hours	InTime	OutTime	Lunch	Tuesday	Tuesday Date	Hours	InTime	OutTime	Lunch
18264	Jane Doe							Monday	06/22/15	6	8:00	14:30	0.5	Tuesday	06/23/15	6	8:00	14:30	0.5
18602	Jason Thomas	Sunday	06/21/15	8	16:00	23:59	0	Monday	06/22/15	8	16:00	23:59	0						
17529	John Smith	Sunday	06/21/15	11	10:00	21:30	0.5	Monday	06/22/15	4	17:00	21:00	0						
18509	Mary Harris	06/21/15	6	11:00	17:00	0		Monday	06/22/15	6	9:00	15:00	0	Tuesday	06/23/15	6	11:00	17:00	0

I am hoping to post in the correct columnar format. Please help.

Thank you.

[zmbd]

So if I understand correctly, you are looking for a calendar layout with the weekdays as the header-row and the employee information as the first column?

Start with a crosstab query:
Make summary data easier to read by using a crosstab query
Once setup, you go to the table area in design view, right click, properties, column headers, enter the correct names.

You should read thru Allen Browne's Crosstab query techniques before you get started.

If you get stuck... post back!