Dlookup

[sambrierley]

Hi all,

im pretty sure ive got the quotes in the wrong place somewhere but its driving me round the bend.

DLookup("[Explanation]", "[Hours]", "[AlphaName] = '" & AlphaName & "'" And "[Week No] =" & WeekNo And "[ID] =" & IDMin)

AlphaName is a string
both WeekNo and ID are integers.

thanks for any help.

 

[pr2-eugin]

DLookup("[Explanation]", _
        "[Hours]", _
        "[AlphaName] = '" & AlphaName & _
        "' And [Week No] = " & WeekNo & _
        " And [ID] = " & IDMin)

Does this help?

 

[sambrierley]

it does thank you.
as a side ive been struggling with multiple criteria for a while, setting it out like that is a good way of doing it. thank you

 

[Minty]

Try;

DLookUp("[Explanation]", "[Hours]", "[AlphaName] = '" & [AlphaName] & "'  And [Week No] =" & [WeekNo] & "And [ID] =" & [IDMin])

Edit - Too late