Query help on expression? Need Last Date

[hvns]

Hello,

I am trying to make a query on a table that has multiple dates for a specific number...

Example
Order # 1234 has shipped multiple times over a period to completed the order:

Order# Due Date Date Shipped
1234 1/1/08 12/31/07
1234 1/1/08 1/1/08
1234 1/1/08 2/15/08


I want it to only return the last date... te record with 2/15/08 not the others... some help or pointing me int he right direction would be greatly apprecaited...

THanks.
John

 

[SkipVought]

Hi,

Select
Order#, [Due Date], Max([Date Shipped])
...
Group By 
Order#, [Due Date]

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[hvns]

thank you very much... it is frustrating trying somethings that are very simple after not doing them for 6-7 years...

much appreciated..

John

 

[SkipVought]

BTW,

Having Order# and Order Due Date in the same table along with multiple Order Ship Dates, is not a best and accepted database design.

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[hvns]

I agree but Since I can only access this data through a ReadOnly ODBC - that data base was set up by antoher company / application so i have to work with what I have and make it flow... MAS90 - until I can get more / better trainging with their tools...

I totally agree with you...

 

[SkipVought]

Ya gotta do what ya gotta do!

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}