DLookup Help

[Alex Motilal]

Hi everybody,


This is in continuation of an earlier post, which I closed solved after getting a solution from Weekend00. However, now I face another problem.
The 1st Shift Hank run is erroneous when data for multiple Frames are entered.
SQL for Query ‘SpinningFramesHanksRun’ is as follows:


SELECT tblHankMeterReading.*, tblDateWorked.DateWorked, ([1stShiftReading]-DLookUp("[3rdShiftReading]","SpinningFramesHanksRun","[DateWorked]=#" & DMax("[DateWorked]","SpinningFramesHanksRun","[DateWorked]<#" & [DateWorked] & "#") & "#")) AS 1stShiftHankRun, ([2ndShiftReading]-[1stShiftReading]) AS 2ndShiftHankRun, ([3rdShiftReading]-[2ndShiftReading]) AS 3rdShiftHankRun, tblSpinningFrames.frameMake
FROM tblSpinningFrames INNER JOIN (tblDateWorked INNER JOIN tblHankMeterReading ON tblDateWorked.DayWorkedID = tblHankMeterReading.shiftDay) ON tblSpinningFrames.frameID = tblHankMeterReading.frameID;


Is it possible to include frameID field in the DLookup Criteria?
With thanks,
Alex

[pbaldy]

Sure; this good reference on the syntax includes a multiple criteria example at the bottom:

DLookup Usage Samples

[Alex Motilal]

Thank u pbaldy. The usage samples solved my problem.
Alex

[pbaldy]

Happy to help Alex.