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. I can add additional columns to spreadsheet if needed
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)
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. I can add additional columns to spreadsheet if needed
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)