|
 |
access thread: Ascending Sort - Programmatically
Message #1 by Walt Morgan <wmorgan@s...> on Fri, 15 Feb 2002 15:15:48 -0600
|
|
SortOrder Property
You use the SortOrder property to specify the sort order for fields and
expressions in a report. For example, if you're printing a list of
suppliers, you can sort the records alphabetically by company name.
Setting
The SortOrder property uses the following settings.
Setting Visual Basic Description
Ascending False (0) (Default) Sorts values in ascending (A to Z, 0 to 9)
order.
Descending True (?1) Sorts values in descending (Z to A, 9 to 0) order.
You can set the SortOrder property by using the Sorting And Grouping box, a
macro, or Visual Basic.
In Visual Basic, you set the SortOrder property in report Design view or in
the Open event procedure of a report by using the GroupLevel property.
Message #2 by "e n z o" <enzaux@y...> on Sat, 16 Feb 2002 05:38:11 +0800
|
|
Thanks Walt!
Enzo :)
----- Original Message -----
From: "Walt Morgan" <wmorgan@s...>
To: "Access" <access@p...>
Sent: Saturday, February 16, 2002 5:15 AM
Subject: [access] Ascending Sort - Programmatically
>
> SortOrder Property
>
>
> You use the SortOrder property to specify the sort order for fields and
> expressions in a report. For example, if you're printing a list of
> suppliers, you can sort the records alphabetically by company name.
>
> Setting
>
> The SortOrder property uses the following settings.
>
> Setting Visual Basic Description
> Ascending False (0) (Default) Sorts values in ascending (A to Z, 0 to 9)
> order.
> Descending True (-1) Sorts values in descending (Z to A, 9 to 0) order.
>
>
> You can set the SortOrder property by using the Sorting And Grouping box,
a
> macro, or Visual Basic.
>
> In Visual Basic, you set the SortOrder property in report Design view or
in
> the Open event procedure of a report by using the GroupLevel property.
>
>
>
>
|
|
|
View Cart
