Grouping (1 Viewer)

[gisash1]

I have a table which is looks like that:

1 2 3
3135-10 Style 1 Brown
3135-40 Style 1 Brown
3135-20 Style 1 Brown
4009-30 Style 2 Green
4009-10 Style 2 Green
4009-20 Style 2 Green
4009-CT Style 2 Green
3135-20 Style 1 Red
3135-10 Style 1 Red
3135-30 Style 1 Red



Is it possible to sort the table in this way?

1 2 3
3135-10 Style 1 Brown
3135-20 Style 1 Brown
3135-40 Style 1 Brown
3135-10 Style 1 Red
3135-20 Style 1 Red
3135-30 Style 1 Red
4009-10 Style 2 Green
4009-20 Style 2 Green
4009-30 Style 2 Green
4009-CT Style 2 Green


Because whatever I try it goes like that:

1 2 3
3135-10 Style 1 Brown
3135-10 Style 1 Red
3135-20 Style 1 Brown
3135-20 Style 1 Red
3135-30 Style 1 Red
3135-40 Style 1 Brown
4009-10 Style 2 Green
4009-20 Style 2 Green
4009-30 Style 2 Green
4009-CT Style 2 Green


Thank you very much in advance

 

[Jon K]

Try this query (replacing with the correct field names and table name):-

SELECT [Field1], [Field2], [Field3]
FROM [TableName]
ORDER BY left([Field1],4), [Field3], Right([Field1],2)
.

 

[gisash1]

Jon, thanks a lot,
I've tried to creat the quiry in existing DataBase and definitely I miss something. Could you look through my table, thank you!!

 

[gisash1]

forgot to attach Zip

 

[gisash1]

Jon, Thanks
I used Left(InStr([Field],"-")-1) , it's working now
Thanks again