Help With SELECT And ORDER Clause...

I am working on a commercial website that is using ASP and an access database.

I have a pretty elaborate select statement that works, except for part of the ORDER clause.

Here is the scenario.... my client sells automotive parts...

Table 1: (itemsku) holds part numbers
Table 2: (itemveh) holds vehicles that work with those parts along with some descriptive clarification (cab size, bed size, years, ...)
Table 3: (make) holds the vehicles make name (ford, chevy, ...)
Table 4: (model) holds the vehicles model name (F150, Ram, Silverado...)

I need to get a list of parts and their approriate descriptions and sort it by Make, Model, Specific Description, and year.

Ideally, it should look like this:

Chevy: Silverado, Longbed, 2007-2008
Chevy: Silverado, Longbed, 1999-2006
Chevy: Silverado, Shortbed, 2007-2008
Chevy: Silverado, Shortbed, 1999-2006
Ford: F150, Longbed, 2004-2008
Ford: F150, Longbed, 1997-2003
Ford, F150, Shortbed, 2004-2008


My select statement reads as follows (spaced out for readability):



select

itemsku.id, itemsku.item_id, itemsku.sku, itemsku.desc_sku,

itemveh.yr_beg,itemveh.yr_end,itemveh.desc_veh,

model.name as modelname,

make.name as makename

from

((itemsku left join itemveh on itemsku.id=itemveh.itemsku_id)

left join model on itemveh.model_id = model.id)

left join make on model.make_id=make.id

where itemsku.item_id=4

order by

make.name,model.name,itemsku.desc_sku




If I put it as listed, all sorts properly, except for the years. As soon as I add to the end of the order by....

, itemsku.yr_beg desc

Then, the desc_sku portion does NOT sort properly, but the years do. I have tried dropping the desc as well to see if that would help, but the desc_sku does not play into the sort factor if the yr_beg is added.

Am I missing something or is their a limit as to the number of fields in an ORDER?

Thanks ahead of time....

Pete