Finding Last 4 occurrences

Hello all,

I am having a mental block trying to get a query to work. I have work orders for part numbers, and I want to get up to the last four work orders for each part number.

As an example, if I have the following data

Order	Part
1	A
2	A
3	A
4	A
5	A
6	A
7	B
8	B
9	B

What I would like returned is:

1	A
2	A
3	A
4	A
7	B
8	B
9	B

It seems like there should be a way, but I can't come up with it.

Thanks for any help you can provide.

Jim Reinardy,
Orion Corporation Received on Tue Nov 23 1999 - 14:02:24 CST