Query many in one row

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

  1. dordije

    dordije New Member

    Sep 26, 2007
    Likes Received:
    Trophy Points:
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice