Results 1 to 3 of 3

Thread: Formula Field

  1. Jun 20th, 2004, 08:10 AM #1
    shersu
    shersu is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2003
    Location
    India
    Posts
    318

    Formula Field

    I have a table in Access with fields as follows:

    EmpCode
    Month_Year
    Percentage of Availability (PA)

    I have another table called StaffMaster which has the following fields:

    EmpCode
    EmpName
    Dept

    In the report, I wish to retrieve and display records as follows:

    Month1 Month2 Month3 Month4

    EmpCode EmpName PA PA2 PA3 PA4

    Can this be accomplished? I have a vague idea that it can be done using formula fields, don't know. Please help. Urgent!

    Thanks
    Reply With Quote Reply With Quote
  2. Jun 20th, 2004, 09:19 AM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    What you are describing is a "Cross Tab" report. The help file explains how to create these reports.
    Reply With Quote Reply With Quote
  3. Jun 22nd, 2004, 12:19 AM #3
    shersu
    shersu is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jul 2003
    Location
    India
    Posts
    318
    I saw that in the help file. But I don't know how it can be done. If you could help me please...

    Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width