sorting difference query-report

[Jur Schagen]

I have this weird sorting problem. I have a report that is based on a
query. The query is sorted on field A, and if I run it seperately it
is decently sorted on that field. However, if I call the report, it is
sorted on field B. I am not using the "Order by"-property of the
report; in fact, if I say "Field A" in it, the report is STILL sorted
on field B.

Any suggestions?

[Stewart Allen]

Re: sorting difference query-report

Have a look at Sorting and Grouping. This is located under the View menu or
click the icon to the right of the hammer and spanner icon on the toolbar.

Stewart

"Jur Schagen" <jurschagen@hot mail.com> wrote in message
news:8427b0d7.0 402160129.28660 6ec@posting.goo gle.com...[color=blue]
> I have this weird sorting problem. I have a report that is based on a
> query. The query is sorted on field A, and if I run it seperately it
> is decently sorted on that field. However, if I call the report, it is
> sorted on field B. I am not using the "Order by"-property of the
> report; in fact, if I say "Field A" in it, the report is STILL sorted
> on field B.
>
> Any suggestions?[/color]

[Bas Cost Budde]

Re: sorting difference query-report

Stewart Allen wrote:[color=blue]
> Have a look at Sorting and Grouping. This is located under the View menu or
> click the icon to the right of the hammer and spanner icon on the toolbar.
>
> Stewart
>[/color]
And be aware that for a report a new (temporary) query is created.
Sorting the source query wastes time.


--
Bas Cost Budde

http://www.heuveltop.org/BasCB

but the domain is nl