Hi all....been trying to "learn myself" some SQL...I am able to run basic and moderate stuff, but normally rely on Excel to massage data into final format and calculations.
I am sure you could all do this in your sleep, but it is driving me crazy.....
I have a table (REPS) contain reps info, including their IDNumber and region.
i can get the results like so:
but I am trying to get the results to appear with the region as column headers and the reps below in the column:
Any help of insight would be appreciated....
BTW....using QMF for Windows V8 (yeah - that is what the company provided)