I working on a report to give me an order number, but not just any, but the first date a particular order is ship.

Here's my example data:

Data A:

Order# Orderline Quantity Order Date Ship
----- ---------
2005 1 3 3/3/07
3 2 3/15/07
5 4 4/20/07

Data B:

Order# Orderline Quantity Order Date Ship
----- ---------
2005 1 3 3/3/07

Data B is what I want to have on my reports. Incase my example data doesn't show correctly:
In my Data A I have my order: 2005. In that order alone i have order line 1, quantity of 3 and ship date 3/3/07. Line 3 has quantity of 2 and ship date 3/15/07. Finally line 5 has quantity of 4 and ship date 4/20/07. This is how my report is now.

I want my report to only show the first ship date for my order 2005 which is 3/3/07.

Anyone know how I can accomplish that? Any advice is appreaciate.

Wind

How can you explain the things you cannot see?