This seems like such a easy question, but I cannot for the life of me figure this out.
This access query works fine:
When I try to put it in the control source property of a text_box, it completely fails.Code:SELECT Format(modified,"MM/DD HH:MM AM/PM") & [Modified BY] AS Expr1 FROM dual;
Any idea of how I can get this to work?Code:=Format([modified],"MM/DD HH:MM AM/PM") & [Modified BY]
Thanks!