Can you tell me how to eliminate duplicate records?  In the example below the only unique value is the Room#.  I only want to return on value per date.  What is the best approach?

Date           Time          Room   Test          Result

4/24/2012   9:12:00AM  2202  CREATININE  1.00 mg/dL  (0.72-1.25)

4/24/2012   9:12:00AM  2315  CREATININE  1.00 mg/dL  (0.72-1.25)

4/24/2012   9:12:00AM  3201  CREATININE  1.00 mg/dL  (0.72-1.25)