Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Dynamic Crosstab Query (https://www.askmehelpdesk.com/showthread.php?t=60772)

  • Feb 6, 2007, 08:09 PM
    JasonChand
    Dynamic Crosstab Query
    I have this payroll database but would like to switch around the row data
    Into columns:

    Report has

    Gross Employe SS Employer SS

    Week1
    Week2
    Week3
    Etc for month


    I want it like this


    Week 1 Week 2 Week 3 Week 4 Week 5

    Gross
    Employee SS
    Employer SS

    I will do this report for each month so the columns will remain but data
    Must be for the particular month.

    Please assist

    Thanks

    Jason Chand

  • All times are GMT -7. The time now is 04:24 PM.