#5 is 95% good, but some values don't sort correctly.
Results from #5 and #7 sort order
ExtraFld P_Value
1 1
1 1
1 .68
2 2.2
2 1.6
2 1.5
The rest seems OK
I think what I need is to convert P-Value into a Number in ExtraFld and then sort on that number. I would like to do it in a query or VBA. Some Values will be decimal, some K = *1000, some M= *1000000, and some Values maybe blank, if I enter all Letters, leave ExtraFld blank. May have some other criteria on P_Value data. I believe Number field should sort correctly.
Thanks,
Tom