I am trying to get the average of 2 different total columns to appear in a 3rd column. Column A is where i want the average to appear, B is total number of cases sold and C is the total Dollars. So how do i get C/B=A? Any help would be great!
Novice
Windows XP 
Access 2016
I am trying to get the average of 2 different total columns to appear in a 3rd column. Column A is where i want the average to appear, B is total number of cases sold and C is the total Dollars. So how do i get C/B=A? Any help would be great!
VIP
Windows Vista Access 2010 32bit
In a query,turn on sums,
count(cases), sum(dollars)
in a 2nd query, use the 1st query and calc the Avg.
Novice
Windows XP Access 2016
Thank you for your help! But how exactly to i get the 2nd Query to provide the average of the columns that i need?This is the picture of the Query i currently have. what would the 2nd one need to look like?
Posting Permissions
Reply With Quote