Dcount with multiple criteria

[muralidaran]

Hi
I have problem in DMax which i tried but no luck, could someone help me to solve this please.

Rev# - Is a numeric field.
JobNumber - Is a text field.
Department - Is a text field.

Max_Rev = DMax("[Rev#]", "SCR_Run", "[JobNumber]=" & Me.JobNumber & "AND [Department]=" & Me.Department)

Sorry for the wrong subject.

Thanks
Ram

 

[Ranman256]

Strings must have quotes around them as delimiters
numbers have none
dates use # delimiters

Max_Rev = DMax("[Rev#]", "SCR_Run", "[JobNumber]='" & Me.JobNumber & "' AND [Department]='" & Me.Department & "'")

 

[muralidaran]

Thanks.... given solution worked well and I understood to use deliminator with string.