Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2006
    Posts
    2

    Unanswered: Problem in Access-Report layout(Cross tab type)

    //working with MS ACCESS-2003

    I have half a dozen projects handled by a
    dozen people under the company heading.i
    have a db which contains PrjID & PrjName
    and also have a master table which stores
    down daily time sheets of all the employees.


    PROJECT
    PRJID--PRJNAMES-
    1----- PROJ1
    2-----PROJ2
    3-----PROJ3
    EMPLOYEE
    EMPID----EMPNAME---- DPT
    A--------- aaa--------TECH
    B--------- bbb--------VENER
    C---------ddd--------CARV


    i store details in my master table in this format

    EMPID--DATE----PRJID----HRS
    A-----1-6-04----1---------5
    A-----1-6-04----3---------4
    B-----1-6-04----2---------9
    C-----1-6-04----2---------2
    C-----1-6-04----1---------2
    C-----1-6-04----3---------5
    *-----*---------*-------- *
    *-----*---------*---------*
    *-----*---------*---------*
    *-----*---------*---------*
    A-----30-6-04--3---------9
    B-----30-6-04--1---------9
    C-----30-6-04--2---------9




    i want a report - the time sheet for a
    particular emp for a particular month

    my problem is it s layout..
    the first columns should contain -date
    the rest of the columns in that row(heading)
    should contain the contents of the table _PROJECT
    (prjNames)

    report should be

    THE TIME SHEET OF THE EMPLOYEE-A FOR THE MONTH
    JUNE-2004
    -------------------------------------------------
    ------------------------------------------------!
    NAME (EMPID)A !
    ------------------------------------------------!
    DATE! PRJID(1) !PRJID(2) PRJID(3) DAILY-TotAL !
    G-(Generate) !
    ------------------------------------------------!
    1-6-4---5(HRS)--#----------4------!--- 9------!
    2-6-4---4-------4----------1-------!--- 9------!
    3-6-4---4-------2----------#-------!--- 6------!
    ***----*-------*----------*-------!--- *------!
    ***----*-------*----------*-------!--- *------!
    ***----*-------*----------*-------!--- *------!
    30-6-4--#------#----------9-------!--- 9------!
    -----------------------------------------------!
    Total G-(13)#--G-(6)------G-(14)---!---33-----!
    -----------------------------------------------!
    #SO WITH A TIME SHEET OR WITH THE HELP OF A FILTER WITH TIME DURATION
    WE SHOULD GET A RESULT OF TIME SPENT BY A PARTICULAR EMPLOYEE ON EACH
    PROJECT ON A PARTICULAR MONTH/PERIOD

    #this is important--the contents of the table, PROJECT-should be
    in one of the heading and the corresponding timings should be displayed in
    the columns below to the respective date fields
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •