Search results for query: *

Thanks for answering. I have a report that needs the results of 160 queries. I understand that the report must have a single record source. How do I create a single record source to hold the results of 160 queries?

I am working really hard on a report that needs the results from many queries to populate its controls. Can I write a function for the control's ControlSource that retrieves a query's results?

I am new to all of this and am really stumped. I have a report that needs to summarize a database based on several criteria. For example: query Q1 filters the table on criteria a, b, c, and d. This results in a few records but are are reduced to 1 row by the sum of column d. Q2 does the same...

I am new to all of this and am really stumped. I have a report that needs to summarize a database based on several criteria. For example: query Q1 filters the table on criteria a, b, c, and d. This results in a few records but are are reduced to 1 row by the sum of column d. Q2 does the same...

Dear JonFer, The query listed above is an example of a query that doesn't work when there are no recorde to return. However, I restructured the db and the query so that at least 1 record will now be selected. Yes, the queries are all the same except for different regions, credit terms and...

Thank you for responding so quickly. I know that there are no records with this query. What I need is for the Report's record source query to return other values. The whole record source query has many queries within it and the whole record source query fails to return any values even though...

I am new to Access but I have gotten deep. I have a report that is populated by a large number of individual queries. The data source for the report is a single query linked to the individual (large number) queries. When one or more individual queries returns nothing (null?) then none of the...