Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Datasheet Structure

Discussion in 'Information Technology' started by F1stman, Jul 28, 2006.

  1. F1stman

    F1stman
    Expand Collapse
    Guest

    Hey Everyone,
    First of all, does anyone know of a good resources online (besided MS pages)
    with good access reports info or tutorials? If you could post a link that
    would be great. Now the REAL question:
    I have created a financial tracking database and now I have gotten creating
    an exhibit using my data. My database is composed of three primary tables set
    up like so:
    Project Table(Including Project Fund Source Codes)--->Allocation
    Table(Related to PFS Codes)--->Allocation Ledger(Related to Allocation Unique
    ID)
    This is a simplified version but it serves my purpose here. I am trying to
    create an exhibit, preferably a report but I could use a form, that will
    divide up the data like so with a list of allocations on the left and PFS
    Codes on top, placing the amount under the appropriate PFS Code and obviously
    on the row with the correct allocation:
    ____________________________________________________________________
    General Project Information...
    ____________________________________________________________________
    PFS 1 PFS 2 PFS 3
    PFS 4
    Allocation 1 $$$
    Allocation 2 $$$
    Allocation 3 $$$$
    Allocation 4 $$$$
    -----------------------------------------------------------------------------------------------
    Totals $$$ $$$$ $$$$
    Other Calculations $$$ $$$ $$$
    ------------
    I am familiar with access in general but new to reports. How can I go about
    organizin my information like I want. Is it possible. I have read up on many
    things about reports and experimented a lot but cannot find a solution. Thank
    you.
     
  2. Loading...

    Similar Threads Forum Date
    Structure Of The Guru Granth Sahib New to Sikhism May 30, 2016
    Heritage 16th-century Sikh Structures Identified For Preservation In Tarn Taran History of Sikhism Mar 10, 2015
    SciTech Meditation and Brain Structure Breaking News Jan 7, 2014
    World Toilet Trouble: New Technology and Infrastructures with Dr. Doulaye Kone Breaking News Oct 26, 2013
    General Management structure of Sikh religion and the preaching class. History of Sikhism Mar 30, 2013

  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi,

    you can use the same subreport multiple times to report the
    columns of information

    make calculated controls on the report for linking the columns:

    Name --> PFS1
    ControlSource --> ="PFS 1"

    Name --> PFS2
    ControlSource --> ="PFS 2"

    etc

    Depending on how the labels on the left column are stored,
    you can render those using the detail section and then put
    the same subreport (so it will be used multiple times --
    have the same ControlSource but a different Name) in each
    "cell" under the PFS columns

    LinkMasterFields --> AllocationID, PFS1 (or PFS2, etc)
    LinkChildFields --> AllocationID, PFS

    as for calculating totals... in the code behind the report:

    'dimension global variables at the top:
    DIM gPFS1total as currency, gPFS2total as currency, etc

    'initialize variables on the ReportHeader format event:
    gPFS1total = 0
    gPFS2total = 0
    etc

    'use the detail Format event to add things up
    if me.PFS1.subreport.HasData then
    gPFS1total = gPFS1total _
    + me.PFS1.subreport.controlname
    end if

    'use the ReportFooter event to write totals
    me.PFS1total = gPFS1total
    me.PFS2total = gPFS2total
    etc

    Warm Regards,
    Crystal
    MVP Microsoft Access

    remote programming and training
    strive4peace2006 at yahoo.com
    *
    Have an awesome day ;)


    F1stman wrote:
    > Hey Everyone,
    > First of all, does anyone know of a good resources online (besided MS pages)
    > with good access reports info or tutorials? If you could post a link that
    > would be great. Now the REAL question:
    > I have created a financial tracking database and now I have gotten creating
    > an exhibit using my data. My database is composed of three primary tables set
    > up like so:
    > Project Table(Including Project Fund Source Codes)--->Allocation
    > Table(Related to PFS Codes)--->Allocation Ledger(Related to Allocation Unique
    > ID)
    > This is a simplified version but it serves my purpose here. I am trying to
    > create an exhibit, preferably a report but I could use a form, that will
    > divide up the data like so with a list of allocations on the left and PFS
    > Codes on top, placing the amount under the appropriate PFS Code and obviously
    > on the row with the correct allocation:
    > ____________________________________________________________________
    > General Project Information...
    > ____________________________________________________________________
    > PFS 1 PFS 2 PFS 3
    > PFS 4
    > Allocation 1 $$$
    > Allocation 2 $$$
    > Allocation 3 $$$$
    > Allocation 4 $$$$
    > -----------------------------------------------------------------------------------------------
    > Totals $$$ $$$$ $$$$
    > Other Calculations $$$ $$$ $$$
    > ------------
    > I am familiar with access in general but new to reports. How can I go about
    > organizin my information like I want. Is it possible. I have read up on many
    > things about reports and experimented a lot but cannot find a solution. Thank
    > you.
     
  4. F1stman

    F1stman
    Expand Collapse
    Guest

    Thank you so much Crystal. You've put me on the right track. Have a wonderful
    day. Adam

    "strive4peace" wrote:

    > Hi,
    >
    > you can use the same subreport multiple times to report the
    > columns of information
    >
    > make calculated controls on the report for linking the columns:
    >
    > Name --> PFS1
    > ControlSource --> ="PFS 1"
    >
    > Name --> PFS2
    > ControlSource --> ="PFS 2"
    >
    > etc
    >
    > Depending on how the labels on the left column are stored,
    > you can render those using the detail section and then put
    > the same subreport (so it will be used multiple times --
    > have the same ControlSource but a different Name) in each
    > "cell" under the PFS columns
    >
    > LinkMasterFields --> AllocationID, PFS1 (or PFS2, etc)
    > LinkChildFields --> AllocationID, PFS
    >
    > as for calculating totals... in the code behind the report:
    >
    > 'dimension global variables at the top:
    > DIM gPFS1total as currency, gPFS2total as currency, etc
    >
    > 'initialize variables on the ReportHeader format event:
    > gPFS1total = 0
    > gPFS2total = 0
    > etc
    >
    > 'use the detail Format event to add things up
    > if me.PFS1.subreport.HasData then
    > gPFS1total = gPFS1total _
    > + me.PFS1.subreport.controlname
    > end if
    >
    > 'use the ReportFooter event to write totals
    > me.PFS1total = gPFS1total
    > me.PFS2total = gPFS2total
    > etc
    >
    > Warm Regards,
    > Crystal
    > MVP Microsoft Access
    >
    > remote programming and training
    > strive4peace2006 at yahoo.com
    > *
    > Have an awesome day ;)
    >
    >
    > F1stman wrote:
    > > Hey Everyone,
    > > First of all, does anyone know of a good resources online (besided MS pages)
    > > with good access reports info or tutorials? If you could post a link that
    > > would be great. Now the REAL question:
    > > I have created a financial tracking database and now I have gotten creating
    > > an exhibit using my data. My database is composed of three primary tables set
    > > up like so:
    > > Project Table(Including Project Fund Source Codes)--->Allocation
    > > Table(Related to PFS Codes)--->Allocation Ledger(Related to Allocation Unique
    > > ID)
    > > This is a simplified version but it serves my purpose here. I am trying to
    > > create an exhibit, preferably a report but I could use a form, that will
    > > divide up the data like so with a list of allocations on the left and PFS
    > > Codes on top, placing the amount under the appropriate PFS Code and obviously
    > > on the row with the correct allocation:
    > > ____________________________________________________________________
    > > General Project Information...
    > > ____________________________________________________________________
    > > PFS 1 PFS 2 PFS 3
    > > PFS 4
    > > Allocation 1 $$$
    > > Allocation 2 $$$
    > > Allocation 3 $$$$
    > > Allocation 4 $$$$
    > > -----------------------------------------------------------------------------------------------
    > > Totals $$$ $$$$ $$$$
    > > Other Calculations $$$ $$$ $$$
    > > ------------
    > > I am familiar with access in general but new to reports. How can I go about
    > > organizin my information like I want. Is it possible. I have read up on many
    > > things about reports and experimented a lot but cannot find a solution. Thank
    > > you.

    >
     
  5. strive4peace

    strive4peace
    Expand Collapse
    Guest

    you're welcome, Adam ;) happy to help

    Warm Regards,
    Crystal
    MVP Microsoft Access

    remote programming and training
    strive4peace2006 at yahoo.com
    *
    Have an awesome day ;)


    F1stman wrote:
    > Thank you so much Crystal. You've put me on the right track. Have a wonderful
    > day. Adam
    >
    > "strive4peace" wrote:
    >
    >
    >>Hi,
    >>
    >>you can use the same subreport multiple times to report the
    >>columns of information
    >>
    >>make calculated controls on the report for linking the columns:
    >>
    >>Name --> PFS1
    >>ControlSource --> ="PFS 1"
    >>
    >>Name --> PFS2
    >>ControlSource --> ="PFS 2"
    >>
    >>etc
    >>
    >>Depending on how the labels on the left column are stored,
    >>you can render those using the detail section and then put
    >>the same subreport (so it will be used multiple times --
    >>have the same ControlSource but a different Name) in each
    >>"cell" under the PFS columns
    >>
    >>LinkMasterFields --> AllocationID, PFS1 (or PFS2, etc)
    >>LinkChildFields --> AllocationID, PFS
    >>
    >>as for calculating totals... in the code behind the report:
    >>
    >>'dimension global variables at the top:
    >>DIM gPFS1total as currency, gPFS2total as currency, etc
    >>
    >>'initialize variables on the ReportHeader format event:
    >>gPFS1total = 0
    >>gPFS2total = 0
    >>etc
    >>
    >>'use the detail Format event to add things up
    >>if me.PFS1.subreport.HasData then
    >>gPFS1total = gPFS1total _
    >> + me.PFS1.subreport.controlname
    >>end if
    >>
    >>'use the ReportFooter event to write totals
    >>me.PFS1total = gPFS1total
    >>me.PFS2total = gPFS2total
    >>etc
    >>
    >>Warm Regards,
    >>Crystal
    >>MVP Microsoft Access
    >>
    >> remote programming and training
    >> strive4peace2006 at yahoo.com
    >> *
    >> Have an awesome day ;)
    >>
    >>
    >>F1stman wrote:
    >>
    >>>Hey Everyone,
    >>>First of all, does anyone know of a good resources online (besided MS pages)
    >>>with good access reports info or tutorials? If you could post a link that
    >>>would be great. Now the REAL question:
    >>>I have created a financial tracking database and now I have gotten creating
    >>>an exhibit using my data. My database is composed of three primary tables set
    >>>up like so:
    >>>Project Table(Including Project Fund Source Codes)--->Allocation
    >>>Table(Related to PFS Codes)--->Allocation Ledger(Related to Allocation Unique
    >>>ID)
    >>>This is a simplified version but it serves my purpose here. I am trying to
    >>>create an exhibit, preferably a report but I could use a form, that will
    >>>divide up the data like so with a list of allocations on the left and PFS
    >>>Codes on top, placing the amount under the appropriate PFS Code and obviously
    >>>on the row with the correct allocation:
    >>>____________________________________________________________________
    >>>General Project Information...
    >>>____________________________________________________________________
    >>> PFS 1 PFS 2 PFS 3
    >>> PFS 4
    >>>Allocation 1 $$$
    >>>Allocation 2 $$$
    >>>Allocation 3 $$$$
    >>>Allocation 4 $$$$
    >>>-----------------------------------------------------------------------------------------------
    >>>Totals $$$ $$$$ $$$$
    >>>Other Calculations $$$ $$$ $$$
    >>>------------
    >>>I am familiar with access in general but new to reports. How can I go about
    >>>organizin my information like I want. Is it possible. I have read up on many
    >>>things about reports and experimented a lot but cannot find a solution. Thank
    >>>you.

    >>
     

Share This Page