Report - Query

[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!

 

[John Vinson]

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]

 

[Guest]

Thanks.

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]