Access - Dmax with multiple criteria : I have an issue in Dmax code which i couldnt fix, please help me to rectify.
        Max_Rev = DMax("[Rev#]", "SCR_Run", "[JobNumber]=" & Me.JobNumber & "AND [Department]=" & Me.Department)

Thanks.
Muralidaran.

