weighted average calculation

  • Thread starter Thread starter Guest
  • Start date Start date
You can use the DAvg Function in the code (check help on that option)

DAvg("[FieldName]","[TableName]","Criteria")

Or, create a group by query and in the weight field select Average, in Sql
it will look like:

Select Avg([FieldName]) As NewFieldName From TableName

I don't know the criteria you are using to specify the range of data, but
you can use the above to do that
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weighted Averages 7
Sumproduct on Table with two criteria 2
weighted average 6
Weighted Average Calc for duplicated values only 0
weighted average - 1 column 2
weighted average profit margin 4
How do I calculate a weighted average and exclude the empthy cells 2
Calculate weighted average for 1 column 3

Back
Top