DLookUp problem

[Sue Compelling]

Hi All

By using the following formula, while I don’t get any error message, the
result fails to display in the report. What am I doing wrong). (note:
“writeoff%%†is a query.

=DLookUp("[PER]","[writeoff%%]","[group owner] = ' " & [group owner] & " ' ")

TIA

 

[Duane Hookom]

Do you really have the extra spaces around your single quotes? Try
=DLookUp("[PER]","[writeoff%%]","[group owner] = '" & [group owner] & "'")
or
=DLookUp("[PER]","[writeoff%%]","[group owner] = """ & [group owner] & """")


BTW: I would never name a query with symbols included. I might use
underscores but otherwise limit names to letters and numbers (no spaces).