Reports

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • cory
    #1

    Reports

    Hi,
    I am looking for info on reports in MS Access. I am looking to create a
    report where the report is based on the relationships in the database.

    For Example:
    I have a project for a client. At the end of it I want to print a report
    based on the following structure.

    The top of the relationship is the Client, then under the client falls a
    project number, then under the project number falls equipment where there
    could be many pieces of equipment. Once one of those pieces of equipment
    under the project number is completed for that client, I need to create a
    report of all records associated with that piece of equipment, and submit it
    to the client.

    I have been trying to conquer this task but for some reason I am unable to
    accomplish it. I have a book on Access but it does not explain very well.

    Any comments, suggestions, direction would be appreciated.

    Thanks


    Tags: None
    • Larry Linson
      #2
      Re: Reports

      You can join related tables in a Query and base the Report on the Query. If
      there will be multiple records per piece of equipment, you might look at a
      subreport to show those.

      I'm assuming that you have a Client table, a Project table, an Equipment
      Table, and one other that has multiple records about each piece of
      equipment. You didn't _exactly_ say that... clarify if I misunderstood, or
      if you want to purse details.

      Larry Linson
      Microsoft Access MVP





      "cory" <noone@here.com > wrote in message
      news:w5HNb.2136 0$De.6034@edtnp s84...[color=blue]
      > Hi,
      > I am looking for info on reports in MS Access. I am looking to create a
      > report where the report is based on the relationships in the database.
      >
      > For Example:
      > I have a project for a client. At the end of it I want to print a report
      > based on the following structure.
      >
      > The top of the relationship is the Client, then under the client falls a
      > project number, then under the project number falls equipment where there
      > could be many pieces of equipment. Once one of those pieces of equipment
      > under the project number is completed for that client, I need to create a
      > report of all records associated with that piece of equipment, and submit[/color]
      it[color=blue]
      > to the client.
      >
      > I have been trying to conquer this task but for some reason I am unable to
      > accomplish it. I have a book on Access but it does not explain very well.
      >
      > Any comments, suggestions, direction would be appreciated.
      >
      > Thanks
      >
      >[/color]


        Comment

        • cory
          #3
          Re: Reports

          Yes you are pretty much right on the money with your assumptions.
          There are tables for every component of the equipment though. This is the
          question I have. After creating a query do I have to create a form for
          every component as well, or will a subform suffice?

          Thx


          "Larry Linson" <bouncer@localh ost.not> wrote in message
          news:C9LNb.1950 7$4P6.4913@nwrd dc01.gnilink.ne t...[color=blue]
          > You can join related tables in a Query and base the Report on the Query.[/color]
          If[color=blue]
          > there will be multiple records per piece of equipment, you might look at a
          > subreport to show those.
          >
          > I'm assuming that you have a Client table, a Project table, an Equipment
          > Table, and one other that has multiple records about each piece of
          > equipment. You didn't _exactly_ say that... clarify if I misunderstood, or
          > if you want to purse details.
          >
          > Larry Linson
          > Microsoft Access MVP
          >
          >
          >
          >
          >
          > "cory" <noone@here.com > wrote in message
          > news:w5HNb.2136 0$De.6034@edtnp s84...[color=green]
          > > Hi,
          > > I am looking for info on reports in MS Access. I am looking to create a
          > > report where the report is based on the relationships in the database.
          > >
          > > For Example:
          > > I have a project for a client. At the end of it I want to print a[/color][/color]
          report[color=blue][color=green]
          > > based on the following structure.
          > >
          > > The top of the relationship is the Client, then under the client falls a
          > > project number, then under the project number falls equipment where[/color][/color]
          there[color=blue][color=green]
          > > could be many pieces of equipment. Once one of those pieces of[/color][/color]
          equipment[color=blue][color=green]
          > > under the project number is completed for that client, I need to create[/color][/color]
          a[color=blue][color=green]
          > > report of all records associated with that piece of equipment, and[/color][/color]
          submit[color=blue]
          > it[color=green]
          > > to the client.
          > >
          > > I have been trying to conquer this task but for some reason I am unable[/color][/color]
          to[color=blue][color=green]
          > > accomplish it. I have a book on Access but it does not explain very[/color][/color]
          well.[color=blue][color=green]
          > >
          > > Any comments, suggestions, direction would be appreciated.
          > >
          > > Thanks
          > >
          > >[/color]
          >
          >[/color]


            Comment

            • Marco Simone
              #4
              Re: Reports

              I will try to reply, but I am far from advanced user.
              I had also problem with making report.
              First, I hope your database is properly designed (normalised). I assume that
              you have tables like Larry said.
              You can make query or queries and make report built on queries.
              [color=blue]
              > After creating a query do I have to create a form for
              > every component as well, or will a subform suffice?[/color]
              If you need to make report why would you create form? Form is usually for
              entering data in tables.

              I hope this will help.


                Comment

                • taccea
                  #5
                  Re: Reports

                  Create a Query that links all your tables, view to make sure they link
                  right.
                  Put the equimpment items in the DETAIL band of the report.
                  Set a filter on the Query when you want to print the report that filters out
                  by project number.

                  Taccea

                  "KHRI" <www.lirnor33@a llail.co.il> wrote in message
                  news:#43mvS4BEH A.2804@tk2msftn gp13.phx.gbl...[color=blue]
                  >
                  > "cory" <noone@here.com > ëúá áäåãòä:w5HNb.21 360$De.6034@edt nps84...[color=green]
                  > > Hi,
                  > > I am looking for info on reports in MS Access. I am looking to create a
                  > > report where the report is based on the relationships in the database.
                  > >
                  > > For Example:
                  > > I have a project for a client. At the end of it I want to print a[/color][/color]
                  report[color=blue][color=green]
                  > > based on the following structure.
                  > >
                  > > The top of the relationship is the Client, then under the client falls a
                  > > project number, then under the project number falls equipment where[/color][/color]
                  there[color=blue][color=green]
                  > > could be many pieces of equipment. Once one of those pieces of[/color][/color]
                  equipment[color=blue][color=green]
                  > > under the project number is completed for that client, I need to create[/color][/color]
                  a[color=blue][color=green]
                  > > report of all records associated with that piece of equipment, and[/color][/color]
                  submit[color=blue]
                  > it[color=green]
                  > > to the client.
                  > >
                  > > I have been trying to conquer this task but for some reason I am unable[/color][/color]
                  to[color=blue][color=green]
                  > > accomplish it. I have a book on Access but it does not explain very[/color][/color]
                  well.[color=blue][color=green]
                  > >
                  > > Any comments, suggestions, direction would be appreciated.
                  > >
                  > > Thanks
                  > >
                  > >[/color]
                  >
                  >[/color]


                    Comment

                    • Don Leverton
                      #6
                      Re: Reports

                      Hi,

                      This is an exerpt from the daily FAQ post:

                      12) Don't set your computer to post from the future
                      a) Posting a message with the time/date set to the future causes
                      your message to remain at the top of the queue in most peoples
                      newsreader. Therefore, it has become a common strategy to
                      attract more attention.
                      b) Such posts are generally ignored, and may subject you to
                      criticism by the people in the newsgroup.
                      c) You have now been warned against doing this! Post that way at
                      your own peril.

                      "KHRI" <www.lirnor33@a llail.co.il> wrote in message
                      news:#43mvS4BEH A.2804@tk2msftn gp13.phx.gbl...[color=blue]
                      >
                      > "cory" <noone@here.com > ëúá áäåãòä:w5HNb.21 360$De.6034@edt nps84...[color=green]
                      > > Hi,
                      > > I am looking for info on reports in MS Access. I am looking to create a
                      > > report where the report is based on the relationships in the database.
                      > >
                      > > For Example:
                      > > I have a project for a client. At the end of it I want to print a[/color][/color]
                      report[color=blue][color=green]
                      > > based on the following structure.
                      > >
                      > > The top of the relationship is the Client, then under the client falls a
                      > > project number, then under the project number falls equipment where[/color][/color]
                      there[color=blue][color=green]
                      > > could be many pieces of equipment. Once one of those pieces of[/color][/color]
                      equipment[color=blue][color=green]
                      > > under the project number is completed for that client, I need to create[/color][/color]
                      a[color=blue][color=green]
                      > > report of all records associated with that piece of equipment, and[/color][/color]
                      submit[color=blue]
                      > it[color=green]
                      > > to the client.
                      > >
                      > > I have been trying to conquer this task but for some reason I am unable[/color][/color]
                      to[color=blue][color=green]
                      > > accomplish it. I have a book on Access but it does not explain very[/color][/color]
                      well.[color=blue][color=green]
                      > >
                      > > Any comments, suggestions, direction would be appreciated.
                      > >
                      > > Thanks
                      > >
                      > >[/color]
                      >
                      >[/color]


                        Comment

                        Previous template Next
                        Working...