Recent content by rome123

thank you so much... This resolved my problem :)

My table appears like this with the following columns: Name| CUSTNo| ORderNo.| AcctDate| OrderDate| OrderDescription I would like to write a ms-sql query to return the records of each customer number with the latest OrderDate. One more thing, if the customer has two separate order numbers on...