I have a Query in Access that evaluates a table, AutoType, and counts the occurances of 'D1' in the Type Column. When the query is run it returns 2, which is correct. I am creating a report to display these results but on the report when I set the control source of the text box to the query it shows #Name? when the report is run. Any Ideas.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Report show displaying Query results?
- Thread starter simdan42
- Start date
>when I set the control source of the text box to the query it shows #Name?
Apolgies if I am stating the obvious, but the recordsource of the report should be set to the query, and then the control source of the textbox to the name of the relevant field in your query.....
Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....
Apolgies if I am stating the obvious, but the recordsource of the report should be set to the query, and then the control source of the textbox to the name of the relevant field in your query.....
Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....
- Status
Similar threads
- Locked
- Question
- Locked
- Question
