Data weighting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to apply a weight to either the raw data
in a table, or to and avg of the data on a report?

Thanks in advance
 
Is it possible to apply a weight to either the raw data
in a table, or to and avg of the data on a report?

Thanks in advance

Sure. Add a Weight field to your table, and include it in your
calculations. For example, if you have a field named Score and you
want to weight it in a Totals query, you could use an expression like

SELECT Avg([Score]*[Weight]) AS AvgWeightedScore FROM ...;


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

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


Back
Top