Ok, I have a question that I don't know how to really explain, so here is an example of the table I have:
35 5101 57.32
35 5102 267.44
35 5103 72
The first column (35) is Employee ID.
The second column (5101) represents a certain time code.
And the Last Column (57.32) represents an amount of time.
I am trying to create a query that puts the data like this:
35 57.32 267.44 72
There is about 3500 different Employee ID's and each ID can have up to 10 different time codes. Is there a way of doing this without doing a Make Table or Update query?
Thanks
35 5101 57.32
35 5102 267.44
35 5103 72
The first column (35) is Employee ID.
The second column (5101) represents a certain time code.
And the Last Column (57.32) represents an amount of time.
I am trying to create a query that puts the data like this:
35 57.32 267.44 72
There is about 3500 different Employee ID's and each ID can have up to 10 different time codes. Is there a way of doing this without doing a Make Table or Update query?
Thanks
Last edited:
