mikenelena
Board Regular
- Joined
- Mar 5, 2018
- Messages
- 139
- Office Version
- 365
- Platform
- Windows
I have written a simple query to pull all the files handled for a certain client, and to calculate the number of days the files were open. I would like populate a textbox on a form with an average of those turn-around times. I can calculate the average with a totals query, but when I try to set the data source on the textbox (which I did with the builder), it doesn't work. I get a #Name? error. This was the control source line:
Is it possible to call the data from the query through the textbox control, or should I do it through the On Current event of the form? Some other way?
If someone could point me in the right direction, I would appreciate it very much.
Thanks!
Code:
=[Turn-Around Query New2]![AvgOfTurn-Around]
If someone could point me in the right direction, I would appreciate it very much.
Thanks!