Whats wrong with this DLookup function?

[gojets1721]

I'm pulling my hair out with this one. I have this DLookup function in a report field's control source and it keeps showing #Error.

I can't figure out what's wrong. Is there anything structurally wrong with this function?

=DLookUp("[Raw Number]","tblAudits","[LAST NAME] = SMITH-JOHNSON")

 

[MajP]

need single quotes around strings
"[LAST NAME] = 'SMITH-JOHNSON'"

 

[MajP]

They do not show a good example in dlookup but here in dcound

DCount Function - Microsoft Support

support.microsoft.com

 

[gojets1721]

They do not show a good example in dlookup but here in dcound

DCount Function - Microsoft Support

support.microsoft.com

Thank you! This worked!