ORDER BY

[Dave B]

I have a form that has a list of cities, states, and populations. When I
turn the Order By On property to Yes and Type [State] in the Order By
property, the report still orders the entries by population. I know I could
do this with grouping, but I'm wondering why the Order By property might not
be working.

 

[mike]

How can I use my orderby fields (passed from the form) while still grouping
(sorting&grouping) fields on the report. Their doesn't seem to be a way to
turn off the sorting when I want to group things together.

- Mike

Any order in the sorting and grouping will over-ride the OrderBy property.
It isn't too difficult to set these properties.

--
Duane Hookom
MS Access MVP

I have a form that has a list of cities, states, and populations. When I
turn the Order By On property to Yes and Type [State] in the Order By
property, the report still orders the entries by population. I know I could
do this with grouping, but I'm wondering why the Order By property might not
be working.

 

[Duane Hookom]

Allen Browne has a tip at http://users.bigpond.net.au/abrowne1/ser-33.html
describing how to set the group level expressions in a report.

--
Duane Hookom
Microsoft Access MVP

How can I use my orderby fields (passed from the form) while still grouping
(sorting&grouping) fields on the report. Their doesn't seem to be a way to
turn off the sorting when I want to group things together.

- Mike

Any order in the sorting and grouping will over-ride the OrderBy property.
It isn't too difficult to set these properties.

When

I

turn the Order By On property to Yes and Type [State] in the Order By
property, the report still orders the entries by population. I know I could
do this with grouping, but I'm wondering why the Order By property

might
not

be working.