Hi, this is the first time I have posted a question. I'm really hoping for somebody to help me. I have a text box in a report that I need to populate via a function. The data required (OPENING BALANCE) is already in another query titled: "qryEOD Report Query".
I am using a query (qryEOD Report) to populate the report and I cannot seem to make this text box work - always an error.
This is the function used in the expression builder:
=DLookUp("[qryEOD Report Query].[OPENING BALANCE]","qryEOD Report Query","[qryEOD Report Query].[CP NAME]"="[qryEOD Report].[CP Name]")
Appreciate anyone's help.