DO not understand - DLOOKUP (1 Viewer)

[Gunnerp245]

I want to develop a report from my database with various "assignments" across the top with the start date underneath.

I have a query named NextOccurance. All assignments i.e. SMART are text, Start Date is Date/Time (mm/dd/yyyy).

On a report using a unbound text box for the control source I have entered;

=DLookUp("[START DATE]","NextOccurance","[Assignment]='" & [SMART] & "'")

The report however displays #Name? .

Gunner...

 

[DCrake]

You need to refer to the name of the control on the report as opposed to the name of the field in the table/query.

David