Grouping within a Query

N

NEWER USER

I need some HELP; I'm looking for an expression or coding that will allow me
to group the following examples. I want to Group on the first alpha
character and ALL following numeric characters - OMIT the last alpha
characters. Do I omit the ending alpha letters first and then group (HOW) or
get everything up to the ending alpha letters and then group? As you can see
I have different quantities of number characters as well as ending alpha
characters.

Text Number Result

D82S
D82RM D82

D112RM
D112SM
D112P D112

D8030SM
D8030RP
D8030MY D8030

Any help greatly appreciated.
 
K

KARL DEWEY

Assuming you only have one alpha character preceeding the numerals then this
should do it --
Left([YourField], 1) & Val(Mid([YourField],2,99))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Record Selection 2
Ignore Leading Zeros in Mixed Alpha-Numeric Text Fields Select Query 5
Grouping in one row 4
Problem with SET & REF function 0
Find and compare alpha-numeric convention 2
Sorting Alphanumeric data 6
Creating a field entry from multiple other fields. 1

Top