I am designing this report that should display results from several queries. Most of the queries are counting records meeting various conditions and thats why i figure Imust have various queries. I do not want my report bound to a single query so that I can pull values from the various queries but I have hit a wall trying to specify the recordsource of a control to the result of a query. Its prints #Name? What must I do for the reports to read this value from the query. Would it be better still to use SQL statements to do the summary and have the values from the SQL into the report? How would I do this? I would then not need to have actual queries but just the SQLs calculating the summary on the fly. Your help appreciated.
Report from multiple queries
- Thread starter jgnasser
- Start date
