Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

    I have a problem with the cross-tab. My records in the table are the in out records of each staff. Here are sample data:

    Staff IDDate Time

    426/04/201009:36:00

    426/04/201013:11:00

    426/04/201014:49:00

    426/04/201017:59:00

    427/04/201009:37:00

    427/04/201013:18:00

    427/04/201014:22:00

    427/04/201018:08:00

    428/04/201009:40:00

    428/04/201013:03:00

    428/04/201014:47:00

    428/04/201018:38:00

    429/04/201009:36:00

    429/04/201013:04:00

    429/04/201013:58:00

    429/04/201018:37:00

    526/04/201008:47:00

    526/04/201013:05:00

    526/04/201013:38:00

    526/04/201017:50:00

    527/04/201008:53:00

    527/04/201013:01:00

    527/04/201013:36:00

    527/04/201017:50:00

    528/04/201008:57:00

    528/04/201013:02:00

    528/04/201013:03:00

    528/04/201013:30:00

    528/04/201017:46:00

    529/04/201009:09:00

    529/04/201013:03:00

    529/04/201014:29:00

    529/04/201018:02:00

    529/04/201018:03:00

    Would like to...

Viewing post 1 (of 1 total)