1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Query many in one row

Discussion in 'MS Access' started by dordije, Sep 26, 2007.

  1. dordije

    dordije New Member

    I am new in SQL and I need solution for next problem:

    Suppose we have table T1 with next values

    Person Date Value

    Smith 07/23/2007 A
    Regan 04/12/2007 B
    Cole 07/24/2007 C
    Gigs 01/13/2007 D
    Smith 08/14/2007 B
    Regan 05/06/2007 C
    Gigs 09/03/2007 A
    Smith 12/23/2007 A

    This table can conatin any Value (among A,B,C,D), for any Person in any Date in year 2007.
    If row exists for person it must have value (A,B,C or D).
    One person can have only one row for same date. For any date we can have values for 0,1 or more
    persons. Not all dates in year 2007 are in T1, some can be without any data.

    2) SECOND: I want to generate next report for one month, for example July (07) 2007:

    July 2007

    Person Day01 Day02 ... Day23 Day24 ... Day31

    Smith - - - A - ... -
    Regan - - - - - ... -
    Cole - - - - C ... -
    Gigs - - - - - ... -

    Off course in real life there can be more data for other persons in july.

    I need SELECT or other statement(s) which will produce data as input for report. Or it must be done using some temp table, or ... ?

    Thanks in advance.

Share This Page