Jason(and all, could you be a bit more specific. Could you give me an example of what such a query might look like? Here is an example of one row of the table.
ID# - 1
First name - Joe
Last name - Blow
Emp ID - 512345678
Director - Adams, John
Cost Center - 6600
Cost Center Name - ICU
Position...
Ok, the normalization makes sense, although I have another question. What would be a way in which I could query the master table in order to have the column headings(the course titles that is) appear as values in the new table? I would then have the current value denoting incomplete or complete...
I am trying to come up with a way to aggregate the on-line courses that employee's have been assigned and/or completed into a manageable report. I need to come up with a query/report that groups each employee by Cost Center, and then shows only the courses they have been assigned and completed...
I am trying to come up with a way to aggregate the on-line courses that employee's have been assigned and/or completed into a manageable report. I need to come up with a query/report that groups each employee by Cost Center, and then shows only the courses they have been assigned and completed...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.