"Updating" a report to new query changes and leaving out things like sorting in report?

[StargateFan]

I've run into this 3 times already so hoping there's a way to do. I
create a query, then I create a report based on that query. But I've
then had a change in requirements and have found it very easy to just
go back and change the query. In these 3 cases, it was simple a
matter on how one of the fields was sorted. But the reports continue
to sort by old criteria and so each of the 3 times had to re-create
the reports.

Was wondering what was best approach. I'm guessing there's no way
around this but can a report be made based solely on the behaviour of
a query with the wizard? There is the screen that asks for sorting,
though. But if it could be done, we could then make all changes on
the query itself. Of course, this is for those tricky cases where
we're not yet 100% sure ultimately the final sort management might
want and so are doing something in the meantime, if you know what I
mean.

Or is best approach to change how the report behaves? I don't know
how to do that and I looked and looked for where this might lie in the
properties and then did a quick look in the vb editor, but it's just
so much to take in I didn't see where this would be done. I'm able to
do some rudimentary vb work now and recognize some things but must
admit that didn't know which of the entries fit the bill for sorting a
field in the report. Access vb seems to be considerably different
enough from Excel commands to trip me up <g>.

Thanks for any help.

 

[Keith]

I've run into this 3 times already so hoping there's a way to do. I
create a query, then I create a report based on that query. But I've
then had a change in requirements and have found it very easy to just
go back and change the query. In these 3 cases, it was simple a
matter on how one of the fields was sorted. But the reports continue
to sort by old criteria and so each of the 3 times had to re-create
the reports.

Report sorting and grouping *always* overrides that of the underlying query.
If your report sorting requirements change then make that change to the
report, *not* the query.

Regards,
Keith.
www.keithwilby.com

 

[StargateFanFromWork]

Report sorting and grouping *always* overrides that of the underlying query.
If your report sorting requirements change then make that change to the
report, *not* the query.

How do we change the sort in an existing report, then, pls?

Thanks.

 

[Guest]

From the Menu Bar - View, Sorting and Grouping
or
From the ToolBar Sorting and Grouping button

Select your field for sorting and sort order.

 

[StargateFanFromWork]

From the Menu Bar - View, Sorting and Grouping

Thank you! That's what I was I was missing. Kewl. I just changed the sort
on the report I mentioned. D

 

[John Vinson]

How do we change the sort in an existing report, then, pls?

View the Report's Properties - select Sorting and Grouping.

John W. Vinson[MVP]