Member Avatar for JFunk
JFunk 0 Newbie Poster

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.

Cheers,
JFunk

  • 1 Contributor
  • 0 Replies
  • 58 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.