DLookUp problem

  • Thread starter Thread starter Sue Compelling
  • Start date Start date
S

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
 
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).
 
Back
Top