I have a field in a query containing alpha-numeric data. I have an "order by field" but I am not getting the results I need.
This list represents the way the order by currently works.
3001
3001N
300-4P
3005
300-5B
3005C
This is how they should sort:
300-4P
300-5B
3001
3001N
3005
3005C
Is this possible?
Thanks,
Nancy
This list represents the way the order by currently works.
3001
3001N
300-4P
3005
300-5B
3005C
This is how they should sort:
300-4P
300-5B
3001
3001N
3005
3005C
Is this possible?
Thanks,
Nancy