Unanswered: Access report with a select satement in control source box
I have created a table in access called table1.
It has one field called field1. In field1 I imputed a number say 6.
I then created a query called query1 from table1.
In SQL the query reads as:
I then created a report and in the report I created a text box.
In the text box properties I put in the Record source as:
=(SELECT Table1.field1 FROM Table1)
Now is it possible to use the select statement in the control source box.
I have tried putting it in and I get an error on the report as #Name?.