Max Date Problem 1

[gjmac2]

I am working in Microsoft AccessI have a table call Lab_results. I need to pull the value from the field "Creatine" based on the the last date in the field "Sampledatetime". Is there an expression I can use to acheive this?

Thanks

 

[lameid]

Select LR.Creatinie
From Lab_Results as LR
Where Sampledatetime IN 
    (Select Max(Sampledatetime) 
      From Lab_Results)

 

[gjmac2]

Thanks for the response. Is there a way to do this in Access Jet SQL? In other words, is there a way to input this into the criteria field in design view of the Access query?

Thanks

 

[lameid]

In a new empty query, switch it to SQL view as opposed to design or datasheet view (note the drop down arrow) and paste the SQL I posted replacing anything there (probably Select;). Switch back to design view. The In statement will appear as criteria which you could have entered manually.