legalhustler
Well-known Member
- Joined
- Jun 5, 2014
- Messages
- 1,171
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a report with an unbound textbox field. I go to this fied's control source and use the expression builder to drill down to the query and it's specific field/column (i.e say it has a value of 100) which I want the report to retrieve and display, but it shows a #Name? error. The expression builder automatically gives the correct name of the query and field/column name, so there is no issue with the naming convention.
How can I fix this error so that my textbox in my report returns the value of a specific field in my query?
Below is the expression builder formula. The first bracket syntax is my Query name, the second bracket syntax is the field I want to retrieve: =
Thanks!
I have a report with an unbound textbox field. I go to this fied's control source and use the expression builder to drill down to the query and it's specific field/column (i.e say it has a value of 100) which I want the report to retrieve and display, but it shows a #Name? error. The expression builder automatically gives the correct name of the query and field/column name, so there is no issue with the naming convention.
How can I fix this error so that my textbox in my report returns the value of a specific field in my query?
Below is the expression builder formula. The first bracket syntax is my Query name, the second bracket syntax is the field I want to retrieve: =
Code:
=[Q3 Sum Contracts Less than $1 Million]![SumOfCountOfContract_Action]
Thanks!