I have several queries. I want to sum how many results are found in each query each time i run them. I.e query 1 = 40 results query 2 = 25 results. How do i do this?
Novice
Windows 10 
Access 2010 32bit
I have several queries. I want to sum how many results are found in each query each time i run them. I.e query 1 = 40 results query 2 = 25 results. How do i do this?
Moderator
Windows 10 Access 2016
More info required. Post query SQL and provide an example showing input and expected output.
Welcome to the forum.
Novice
Windows 10 Access 2010 32bit
I dont have any query SQL to provide an example sorry. Just wonder if is possible to sum how many results are found on a query. I have query A, i run it and the number of results that the query found is displayed.
Virtually Inert Person
Windows 10 Access 2016
and explain what a "result" is. Is that a field name and you want to sum all of the values in that field that the query returns?
Or are you asking for a count of the records returned. If the latter, you can use a sql statement in a query calculated field if that's where you want it:
theCount: (SELECT COUNT(*) FROM [query1])
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows 10 Access 2010 32bit
Maybe have a look at this explaing how to add a totals row to your query:
https://support.microsoft.com/en-us/...click%20Totals.
Cheers,
Posting Permissions
Reply With Quote