can someone help me write the syntax to get the sum of a query in a query builder. I want to get the sum of multiple queries in each column. ie (Query: R1-R7)
You're using incompatible terms. "Sum of a query" is meaningless. You can sum fields in a query, but the query itself cannot be summed. Also, your query naming convention leads me to believe this could be handled in a more efficient manner.
Can you demonstrate with data what you would like as results? Post sample starting data (along with datasource and field names) and then what data should result from that initial sample data.
to rephrase, i want to count the total records that meet the criteria query one, and in the second column the total count of records that satisfy query two and so forth. I am using dcount to do this in vba, but this will be more efficient.
Can you demonstrate with data what you would like as results? Post sample starting data (along with datasource and field names) and then what data should result from that initial sample data.
