I'm new to MS access Reports so please bear with me.
I have a text box where I'm trying to set the data source using a SQL Query:
and when I view the report, all I get is "#NAME?" in the text box. I've also tried creating the SQL statement as an Access query (the query works) and using that as the control source but I still get the same result. Any idea what I'm doing wrong?