I have a multiple query with 7 columns. while using Totals, the totals wor at the bottom appears with drop-down menus including:
- none
- count
However, I need the sums for each of the columns.
Could anybody advise me?
Thank you very much !!
I have a multiple query with 7 columns. while using Totals, the totals wor at the bottom appears with drop-down menus including:
- none
- count
However, I need the sums for each of the columns.
Could anybody advise me?
Thank you very much !!
Create the query manually, using the Totals option. You can then specify totals for any of the columns you select.