You're trying to get an equivalent elookup for this sql?
Code:
SELECT TOP 1 [Geochemistry - Samples].SAMP_NUM
FROM tblSelectedDrillHoleandDeclination
INNER JOIN [Geochemistry - Samples]
ON tblSelectedDrillHoleandDeclination.hole_NUM =
[Geochemistry - Samples].SAMP_Hole_NUM
ORDER BY [Geochemistry - Samples].datModified DESC;
copy and paste the above sql into the elookup function's params would look like
Code:
ELookUp("[Geochemistry - Samples].SAMP_NUM", "tblSelectedDrillHoleandDeclination INNER JOIN [Geochemistry - Samples] ON tblSelectedDrillHoleandDeclination.hole_NUM = [Geochemistry - Samples].SAMP_Hole_NUM", , "[Geochemistry - Samples].datModified DESC")