Dlookup

[nybaseball22]

Hello. I am trying to add a dlookup like I use on my forms to pull a
value from an unassociated query onto my report. Is there a way I
have to structure this that is different than a form? I am just
looking up one field in a query called balance. The query is
StatementBalance. It does not depend on anything in the report to
determine the record to pull. The query has already done the work.

Thanks

 

[fredg]

Hello. I am trying to add a dlookup like I use on my forms to pull a
value from an unassociated query onto my report. Is there a way I
have to structure this that is different than a form? I am just
looking up one field in a query called balance. The query is
StatementBalance. It does not depend on anything in the report to
determine the record to pull. The query has already done the work.

Thanks

I'm sure you must have tried this, didn't you?
Were you getting and error?

It's always best practice to copy and paste YOUR code so we can see
what it is you are doing wrong.

The DlookUp is exactly the same.

=DLookUp("[Balance]","StatementBalance")

will work if there is just one record returned by the query.
If there is more than one record returned, then add criteria.

*** Make sure the name of the control is not "Balance". ***

 

[nybaseball22]

I thought I was doing this before, but it wasn't working. That fixed
it, though.

Thanks very much.