I am trying to place an SQL into an unbound field on my form. The SQL is intended to return the maximum date in a field where moduleID = 1. My SQL is as follows:
=(SELECT Max([DCTargetCompletionDate]) AS Expr1 FROM KControl WHERE ModuleID=1;)
I am getting #Name as a result and do not know how to get round this.
Can anybody help?