How to switch my counts in Microsoft Access?
Posted on 2011-04-20
I created an SQL statement to count the number of Full Time and Part Time people that I have in a given store. The only problem is that The headings I have horizontally I want vertically and vice versa.
Right now my query produces:
I want the F and P where the PK is and the PK going down b/c I will have more stores.
Here is my syntax:
SELECT STEP_1.MBFTPT, Count(STEP_1.[MBSS#]) AS PK
WHERE (((STEP_1.MBFTPT)="F" Or (STEP_1.MBFTPT)="P") AND ((STEP_1.MBSTOR)>=100000 And (STEP_1.MBSTOR)<=100999))
GROUP BY STEP_1.MBFTPT
I've tried numerous things, but it doesn't seem to work correctly.
Any help would be greatly appreciated.