Dlookup

[JimP]

Is it possible to use Dlookup in a field on a report, that uses a field in
the report query for criteria?

i.e. not alter the report query to do the Dlookup.

 

[fredg]

Is it possible to use Dlookup in a field on a report, that uses a field in
the report query for criteria?

i.e. not alter the report query to do the Dlookup.

Without any criteria?
=DLookUp("[FieldName]","QueryName")

With criteria on the [SomeField] as a Number datatype?
=DLookUp("[FieldName]","QueryName","[SomeField] = " &
Me![SomeControl])

With criteria on the [SomeField] as a Text datatype?
=DLookUp("[FieldName]","QueryName","[SomeField] = '" &
Me![SomeControl] & "'")