Organizing a drop down (1 Viewer)

[SinKoh]

I have a query that organizes a drop down A-Z. I am looking for a way to organize it A-Z AND Smallest to Largest.

SELECT tblPartNum.PartNumberID, PartNum & ' - ' & PartDesc AS Expr, tblPartNum.Deleted FROM tblPartNum WHERE (((tblPartNum.Deleted)=False)) ORDER BY PartNum & ' - ' & PartDesc;

I need it to sort it out like this
4 digit #'s Ascending
5 digit #'s Ascending
6 digit #'s Ascending
So the list would look like this
1111
1112
1113
11111
11112
11113
111112
111113
111114

 

[spikepl]

That is a plain-vanilla ascending numerical sequence, so what is stopping you?

 

[SinKoh]

i need ALL 4 digit numbers together ascending and then all 5 digit numbers together ascending, etc.
I should have put it like this.
1113
1114
2224
2225
11112
11113
22223
22224
111112
111113
This is how I need it done

 

[spikepl]

Err, again, this is a plain vanilla ascending numerical sequence. Please explain what specifically is stopping you sorting on that? Repeating your requirement does not bring any clarity as to what is stopping you.

 

[SinKoh]

It just simply isn't doing it with the query code I provided.

 

[spikepl]

What has that to do with what you have shown? The query you provided sorts on a string PartNum & ' - ' & PartDesc which is where?

You have listed plain numbers.

You neeed to show a sample of actual original data showing all variations, the actual corresponding query and the actual desired result. Not a story, but samples of data.

 

[SinKoh]

I apologize. I forgot I had the Row source set in the form load event and I was changing the query in the properties which in turn was being overridden by the Form Load event. This I was I shouldn't be coding tired at 4 am. Thank you for your interest in helping though