Sort Records in Access 2007

[Reema]

Hi,

The records in your Microsoft Access 2007 database table can be sorted A to Z or Z to A for text, memo or hyperlink data types.

Number, currency and Autonumber data types can be sorted from smallest to largest or largest to smallest.

The Date/Time data type can be sorted oldest to newest or newest to oldest while the Yes/No data type can be sorted selected to cleared or cleared to selected.

[ExlGuru]

The following user-defined function can be used to sort data in case-sensitive order.

Please Login or Register  to view this content.