User Profile

Collapse

Profile Sidebar

Collapse
hwalker
hwalker
Last Activity: Jul 22 '08, 06:58 PM
Joined: Mar 19 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • hwalker
    replied to How to Point to Dynamic Column Headers in Crosstab Query
    in Access
    The First Crosstab is:

    Code:
    TRANSFORM Sum(MASTER_TABLE.ACT) AS SumOfACT
SELECT TAB_2.OBS_HIERARCHY, MASTER_TABLE.PROJECT_ID, MASTER_TABLE.PROJECT_NAME, TAB_2.RESOURCE_ID, TAB_2.FULL_NAME, MASTER_TABLE.PRIMARY_ROLE, TAB_2.RESOURCE_MANAGER, TAB_2.EMAIL_ADDRESS, TAB_2.EMPLOYMENT_TYPE
FROM ((MASTER_TABLE LEFT JOIN ASE_RESOURCE_EXCLUDE_TABLE ON MASTER_TABLE.RESOURCE_UNIQUE_NAME = ASE_RESOURCE_EXCLUDE_TABLE.NBKID) RIGHT
    ...
    See more | Go to post

      Leave a comment:

    • hwalker
      started a topic How to Point to Dynamic Column Headers in Crosstab Query
      in Access

      How to Point to Dynamic Column Headers in Crosstab Query

      Hello all. Long time reader, first time poster :)

      I'm creating a repot that shows "the last two weeks of data the next 6 weeks of data, week over week".

      So, I have a calculated field called "Week number" as the column header in a crosstab and then in the criteria for that field I put:

      DateDiff("ww",# 12/22/2007#,Now(),0,# 12/22/2007#)-2
      DateDiff("ww",# 12/22/2007#,Now(),0,# 12/22/2007#)-1...
      See more | Go to post
      No activity results to display
      Show More
      Working...