ACC: How to Sort or Group a Query by Using a Portion of a Field's Value (88927)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q88927 Novice: Requires knowledge of the user interface on single-user computers.
SUMMARY
You can sort or group a query by using only a portion of a field's value.
This technique is useful if a field contains values with a set number of
leading or trailing characters that are insignificant to your sorting task.
An example of this might be a part number field that contained the following values:
A-453-34567
A-123-45675
B-234-75658
B-645-65759 and so forth
REFERENCES
For more information about string functions and related functions, search
the Help Index for "String function," "Left function," "Right function,"
and "Len function."
Modification Type: | Major | Last Reviewed: | 5/9/2003 |
---|
Keywords: | kbhowto kbusage KB88927 |
---|
|