Welcome to SPN

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

Sign Up Now!

Report - Query

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

Tags:
  1. Kylie

    Kylie
    Expand Collapse
    Guest

    Hi

    I have done a query from the be of a database, and from the query created a
    report. I have now realised that the data I took from the query wasn't
    exactly correct and it needs adjusted. Is there any way that I can just go
    back to the query, make the required changes, and then have the report change
    without having to redesign the whole report again? (I have set it all up
    with headers/footers/logos/page set up etc, which took some time I don't want
    to have wasted.)

    I hope that this makes sense and that there is an easy answer. I am a very
    novice Access user, so if there is a solution, as many detailed instructions
    as possible appreciated!
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 12 Jul 2006 21:39:01 -0700, Kylie
    <Kylie@discussions.microsoft.com> wrote:

    >Hi
    >
    >I have done a query from the be of a database, and from the query created a
    >report. I have now realised that the data I took from the query wasn't
    >exactly correct and it needs adjusted. Is there any way that I can just go
    >back to the query, make the required changes, and then have the report change
    >without having to redesign the whole report again? (I have set it all up
    >with headers/footers/logos/page set up etc, which took some time I don't want
    >to have wasted.)
    >
    >I hope that this makes sense and that there is an easy answer. I am a very
    >novice Access user, so if there is a solution, as many detailed instructions
    >as possible appreciated!


    Certainly, and it's easy.

    Change the Query.
    Rerun the Report.
    You're done.

    A Report doesn't contain any data; it gets its data from its
    Recordsource, usually a query. Just make sure that the Report's
    Recordsource property contains the name of the query, and you're fine.

    John W. Vinson[MVP]
     
  4. Kylie

    Kylie
    Expand Collapse
    Guest

    Thanks.

    "John Vinson" wrote:

    > On Wed, 12 Jul 2006 21:39:01 -0700, Kylie
    > <Kylie@discussions.microsoft.com> wrote:
    >
    > >Hi
    > >
    > >I have done a query from the be of a database, and from the query created a
    > >report. I have now realised that the data I took from the query wasn't
    > >exactly correct and it needs adjusted. Is there any way that I can just go
    > >back to the query, make the required changes, and then have the report change
    > >without having to redesign the whole report again? (I have set it all up
    > >with headers/footers/logos/page set up etc, which took some time I don't want
    > >to have wasted.)
    > >
    > >I hope that this makes sense and that there is an easy answer. I am a very
    > >novice Access user, so if there is a solution, as many detailed instructions
    > >as possible appreciated!

    >
    > Certainly, and it's easy.
    >
    > Change the Query.
    > Rerun the Report.
    > You're done.
    >
    > A Report doesn't contain any data; it gets its data from its
    > Recordsource, usually a query. Just make sure that the Report's
    > Recordsource property contains the name of the query, and you're fine.
    >
    > John W. Vinson[MVP]
    >
     

Share This Page