Using Crosstab and showing data for the same day?

[spyldbrat]

Hi.



I am trying to create a database that needs to show all information for each employee on the same row. I am creating multiple crosstabs and then creating one big query based off the crosstabs. I have come across a situation where I have two of the same "Category" with different dates for the same period I am creating the crosstab. Is there a way for me to show all the categories listed in a Query?

This what I currently see on the Excel Sheet I am importing from:

Employee Number	FirstName	LastName	Category	Week Day	Violation Date
15135	Employee	Name #1	Other (See Notes)	Wednesday	08/19/15
15135	Employee	Name #1	Late	Wednesday	08/19/15
15135	Employee	Name #1	Late	Thursday	08/20/15

This is how I need to see it. I don't really need the "Week Day" column. This was added because I thought it would be easier to show all the data.

Employee Number	FirstName	LastName	Category	Week Day	Violation Date	Category	Day of Week	Violation Date	Category	Day of Week	Violation Date
15135	Employee	Name #1	Other (See Notes)	Wednesday	08/19/15	Late	Wednesday	08/19/15	Late	Thursday	8/20/2015

[June7]

Don't think crosstabs will accomplish: http://allenbrowne.com/ser-67.html

Options:

1. http://allenbrowne.com/func-concat.html

2. VBA code and writing records to temp table