how do it dlookup

[hatmal]

hi




ay help to do this

dlookup value from query sum

when inter data in data Query

[orange]

Example of DLookup

[June7]

Fix syntax, use concatenation, field references are backwards, text field parameters need apostrophe delimiters.

DLookUp("sumofCount", "sum", "[code1]='" & [code] & "' And [fin_years]='" & [fin_year] & "'")

[hatmal]

thanks

june7