Calculations in a Sum Query

  • Thread starter Thread starter Jasper Recto
  • Start date Start date
J

Jasper Recto

I have a query that sums up several columns and gets a count from one
column. Is it possilble to make anther column that takes the sum value of
the the first few columns and divide them by the count of the last column?

I can't seem to make a equation that uses the sum values in its own query.

Is this possible or do I need to create a new query just for the specific
function?

Thanks,
Jasper
 
Yes, you can add a calcualtion in another column. Your new column would look
like this.

GrandTotal:[TheNameOfYourCalculationsColumn]/[TheNameOfYourCountColumn]

If you have totals in your query, be sure to make the total an expression.

You do do everything in one column if you wanted.

GrandTotal:([Field1]+[Field2]+[Field3])/[Count]
 
THANKS!!!





Ryan said:
Yes, you can add a calcualtion in another column. Your new column would
look
like this.

GrandTotal:[TheNameOfYourCalculationsColumn]/[TheNameOfYourCountColumn]

If you have totals in your query, be sure to make the total an expression.

You do do everything in one column if you wanted.

GrandTotal:([Field1]+[Field2]+[Field3])/[Count]
--
Please remember to mark this post as answered if this solves your problem.


Jasper Recto said:
I have a query that sums up several columns and gets a count from one
column. Is it possilble to make anther column that takes the sum value
of
the the first few columns and divide them by the count of the last
column?

I can't seem to make a equation that uses the sum values in its own
query.

Is this possible or do I need to create a new query just for the specific
function?

Thanks,
Jasper
Click to expand...
Click to expand...
 
Back
Top