Dlookup

  • Thread starter Thread starter JimP
  • Start date Start date
J

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.
 
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.
Click to expand...

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] & "'")
 
Back
Top