Sorting Help

[Don]

I have a "Report" that is created from a "Form". It prints a list of items,
you may consider it a shopping list. In any event I use to run this in
alphabetical order but have since decided to run it as it comes from the
form (random order). My problem is I don't know how to make this happen.
The report is sorted in ascending order and I don't know how to change that.
I see only two options, ascending or descending.
Can you help?
Thanks,
Don.....

[Don Leverton]

Have a look at the "Random sort via SQL in ASP" thread by Muskie 04/12/2007.
The solution thatI propsed there may work for your situation as well.

--
--
HTH,
Don
=============================
E-Mail (if you must) My*****@Telus.net

Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)

I'm an Access97 user, so all posted code samples are also Access97- based
unless otherwise noted.

================================================== ========================

"Don" <vz******@verizon.netwrote in message
news:w04Uh.48$Yh.38@trndny03...

>I have a "Report" that is created from a "Form". It prints a list of
items,
you may consider it a shopping list. In any event I use to run this in
alphabetical order but have since decided to run it as it comes from the
form (random order). My problem is I don't know how to make this happen.
The report is sorted in ascending order and I don't know how to change
that.
I see only two options, ascending or descending.
Can you help?
Thanks,
Don.....

[Larry Linson]

"Don" <vz******@verizon.netwrote

I have a "Report" that is created from a "Form".
It prints a list of items, you may consider it a
shopping list. In any event I use to run this in
alphabetical order but have since decided to
run it as it comes from the form (random order).
My problem is I don't know how to make this
happen. The report is sorted in ascending order
and I don't know how to change that.
I see only two options, ascending or descending.
Can you help?

First, if you are implying that the Form is supplying the data to the
Report, that is in error. Whether or not you create the Report based on a
Form, the data for the Report comes from the Report's RecordSource.

Sorting in Reports is determined by the Sorting and Grouping property. If
you remove the name of the Field(s) from the Sorting and Grouping property,
then there will not be any sorting specified (as you mention, "ascending" or
"descending").

Reports do NOT default to the order in which the RecordSource is sorted --
if that's the way the data is displayed, it's just happenstance, but you
cannot COUNT on it being that way.

Larry Linson
Microsoft Access MVP

[Last Boy Scout]

Order Number
Order Date and time
Don wrote:

I have a "Report" that is created from a "Form". It prints a list of items,
you may consider it a shopping list. In any event I use to run this in
alphabetical order but have since decided to run it as it comes from the
form (random order). My problem is I don't know how to make this happen.
The report is sorted in ascending order and I don't know how to change that.
I see only two options, ascending or descending.
Can you help?
Thanks,
Don.....

Order Number
Order Date and time