Hello people
I am sure that I am just missing the plot on this one
ok - 2 queries
excatly same field names (keep it simple)
I get all the data I want - great - but cannot get it to sort (Numerically )
the first field is numeric and is numbered 1-999 (with gaps ) 1-199 is x and 200-300 is y and 301-400 is z products /information -and there willb e gaps - might only be 5 entries in the 301 to 400 - kind of deal)
anyway union qry 1 comes first then all of the 1's 1 ,10 11,111, where as its should be assending 1,2,3,4,5, etc (sortorderno is numbers)
SELECT[sortorderno],LefthandTitle,Spacer,substance,QuoteSlip,Quoteno,Groupfilter
FROM SlipQuery1
union
SELECT[sortorderno],LefthandTitle,Spacer,substance,QuoteSlip,Quoteno,Groupfilter
FROM SlipQuery2
what have I missed??
order by sortorderno
regards
I am sure that I am just missing the plot on this one
ok - 2 queries
excatly same field names (keep it simple)
I get all the data I want - great - but cannot get it to sort (Numerically )
the first field is numeric and is numbered 1-999 (with gaps ) 1-199 is x and 200-300 is y and 301-400 is z products /information -and there willb e gaps - might only be 5 entries in the 301 to 400 - kind of deal)
anyway union qry 1 comes first then all of the 1's 1 ,10 11,111, where as its should be assending 1,2,3,4,5, etc (sortorderno is numbers)
SELECT[sortorderno],LefthandTitle,Spacer,substance,QuoteSlip,Quoteno,Groupfilter
FROM SlipQuery1
union
SELECT[sortorderno],LefthandTitle,Spacer,substance,QuoteSlip,Quoteno,Groupfilter
FROM SlipQuery2
what have I missed??
order by sortorderno
regards