Orderby question (or is it?)

[DataBug]

Seems like the simplest things trip me up, lol.

I have a sub report that's feed by a query. The records in the sub report are being ordered alphabetically. What I was is for them not to be sorted at all but to list in the order that they are returned in the underlying query (that is, the order in which they were entered).

Any help is much appreciated.

 

[Brianwarnock]

The only way to gaurantee the order which data is supplied in is to take control and sort it, either by date entered if it exists or some sequence number. If you know the order tell the system

Brian

 

[gemma-the-husky]

a report carries its own sorting parameters independent of the sort order of the query. look at sorting and grouping.

Click in the top left solid box in the report design, then right click, and select sorting and grouping. or its on a small icon on the menu bar.