If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Updating" a report to new query changes and leaving out things like sorting in report?
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. |
#2
|
|||
|
|||
"Updating" a report to new query changes and leaving out things like sorting in report?
"StargateFan" wrote in message
... 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 |
#3
|
|||
|
|||
"Updating" a report to new query changes and leaving out things like sorting in report?
"Keith" wrote in message
... "StargateFan" wrote in message ... 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. How do we change the sort in an existing report, then, pls? Thanks. |
#4
|
|||
|
|||
"Updating" a report to new query changes and leaving out thing
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" wrote: "Keith" wrote in message ... "StargateFan" wrote in message ... 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. How do we change the sort in an existing report, then, pls? Thanks. |
#5
|
|||
|
|||
"Updating" a report to new query changes and leaving out thing
"Joe" wrote in message
... 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 or From the ToolBar Sorting and Grouping button Select your field for sorting and sort order. "StargateFanFromWork" wrote: "Keith" wrote in message ... "StargateFan" wrote in message ... 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. How do we change the sort in an existing report, then, pls? Thanks. |
#6
|
|||
|
|||
"Updating" a report to new query changes and leaving out things like sorting in report?
On Wed, 26 Oct 2005 13:26:25 -0400, "StargateFanFromWork"
wrote: 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] |
Thread Tools | |
Display Modes | |
|
|