Report - Query

#1 (**permalink**) 28-Jul-2006, 08:34 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13145-report-query.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13145
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 (**permalink**) 28-Jul-2006, 08:34 AM

On Wed, 12 Jul 2006 21:39:01 -0700, Kylie
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13145
>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13145
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]

#3 (**permalink**) 28-Jul-2006, 08:35 AM

Thanks.

"John Vinson" wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13145
> On Wed, 12 Jul 2006 21:39:01 -0700, Kylie
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13145
> 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]
>