Help with Access Expression DLOOKUP

[gjmac2]

I need help in writing an expression in an Acess query. I need to look for the minimum date foe a particular set of records, and then return the coresponding value for that minimum date.

The table I am working with is: VW_SODIUM SURVEY LAB

I need the minimum date from field: Sampledatetime

I need the corresponding value from field: Serum Creatinine

I have tried using the Dlookup expression, but keep getting errors. Any help would be greatly appreciated.

 

[lespaul]

some thing like this? I didn't use DLOOKUP, I used a subquery to get the MIN datetime...may need some tweaking:

SELECT [Serum Creatinine] FROM [VW_SODIUM SURVEY LAB] WHERE SampleDateTime = (SELECT Min(SampleDateTime) FROM [VW_SODIUM SURVEY LAB])

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com

 

[randy700]

How about...

SELECT [Serum Creatnine], Min(Sampledatetime) As MinOfSampledatetime 
FROM [VW_SODIUM SURVEY LAB] 
GROUP BY [Serum Creatnine]

Randy