Order by not working so well

[SuperDude_123]

Could someone point out why my order by isn't working after all is said and done?

SELECT Database.*FROM [Database]
WHERE ( Symbol like '*' + [Forms]![Form for 3 Filters].[Filter_1] + '*')
	and Database.[Job Number] is not null
	and Database.[Job Number] in (
		SELECT  Database.[Job Number]
FROM [Database]
		where 
		( Symbol like '*' + [Forms]![Form for 3 Filters].[Filter_2] + '*')
and Database.[Job Number] is not null
	)
and Database.[Job Number] in (
		SELECT  Database.[Job Number]
FROM [Database]
		where 
		( Symbol like '*' + [Forms]![Form for 3 Filters].[Filter_3] + '*')
and Database.[Job Number] is not null
	)


UNION


(SELECT Database.*
FROM [Database]
WHERE ( Symbol like '*' + [Forms]![Form for 3 Filters].[Filter_2] + '*')
	and Database.[Job Number] is not null
	and Database.[Job Number] in (
		SELECT  Database.[Job Number]
FROM [Database]
		where 
		( Symbol like '*' + [Forms]![Form for 3 Filters].[Filter_1] + '*')
and Database.[Job Number] is not null
	)
and Database.[Job Number] in (
		SELECT  Database.[Job Number]
FROM [Database]
		where 
		( Symbol like '*' + [Forms]![Form for 3 Filters].[Filter_3] + '*')
and Database.[Job Number] is not null
	))


UNION (SELECT Database.*
FROM [Database]
WHERE ( Symbol like '*' + [Forms]![Form for 3 Filters].[Filter_3] + '*')
	and Database.[Job Number] is not null
	and Database.[Job Number] in (
		SELECT  Database.[Job Number]
FROM [Database]
		where 
		( Symbol like '*' + [Forms]![Form for 3 Filters].[Filter_1] + '*')
and Database.[Job Number] is not null
	)
and Database.[Job Number] in (
		SELECT  Database.[Job Number]
FROM [Database]
		where 
		( Symbol like '*' + [Forms]![Form for 3 Filters].[Filter_2] + '*')
and Database.[Job Number] is not null
	))
ORDER BY [Job Number];

[pbaldy]

How is it not working? Is it perhaps giving you an alphabetic sort when you're expecting a numeric sort?

[SuperDude_123]

Yes, and the Job Numbers are just numbers. Could it be that I have it nested incorrectly?

[isladogs]

If these are numbers stored in a text field, it will sort 'alphabetically'
E.g. 1,11,12,13....2,20,21...3,31 etc

[SuperDude_123]

Shoot! I'm looking to order it in terms of 1,2,3,......11,12,13,....etc

Should I use something else?

[pbaldy]

I'll get out of the way.