Dear all,

see the following data :

Location Part no. Qty. In-date
A1 637A 1000 01-MAY-2004
B1 807K 500 03-MAY-2004
B2 807K 1000 03-MAY-2004
C4 639A 2000 03-MAY-2004
C5 637A 500 11-MAY-2004
C10 807K 1000 03-MAY-2004
D1 639A 2000 04-MAY-2004

Above data is a simplified data for my question. Now, if
I just want to show the data which the In-date is 03-may-
2004, and then the different part no will be
distinguished by insert a row. Below is my wanted result.


Location Part no. Qty. In-date
C4 639A 2000 03-MAY-2004

B1 807K 500 03-MAY-2004
B2 807K 1000 03-MAY-2004
C10 807K 1000 03-MAY-2004