Sorting Problem

[Turk Ries]

I have an Access DB that I need to sort my own way. For example, I need to
make the query or table sort by 123, 123, 123. Not by 111, 222, 333.

We manufacture fiberglass products and we are in the process of trying to
implement "lean manufacturing". This concept requires us to schedule parts
to
be built in a sequential order. In order to accomplish this, we determined
that each part (of which we have 100's of on a daily basis) needs to be
built
according to how much time it takes to build them. We have come up with
actually 6 different time categories that we need to run the parts in.

With that in mind, we assigned various parts with a time category. I.E.,
part #"A" is Time 1. Part "B" is Time 2. Part "C" is Time 3 and so on.

I cannot schedule 2 part "A's" together. That is why I need to sort my
schedule as 1,2,3 - 1,2,3 - 1,2,3 and so on.

Thanks,
Turk

 

[Turk Ries]

I didn't mean to double post, I wasn't aware that this was the same
discussion group that I found on Mcrosoft's website.

Thanks,
Turk