Grouping within a Query

  • Thread starter Thread starter NEWER USER
  • Start date Start date
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.
 
Assuming you only have one alpha character preceeding the numerals then this
should do it --
Left([YourField], 1) & Val(Mid([YourField],2,99))
 
Back
Top