Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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.

    >>
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page