none
How do I make a ranking system?

    Question

  • Hello,

    I'm trying to make a form in Micorsoft Access 2007 that will automatically rank my entires based on certain criteria. The end result will be a targeting system.

    I have certain criteria in columns such as: # of products, 3 of disciplinary actions, # of days delinquent, etc. I want to make a ranking system where the computer can rank the entires I should target first.

    I don't know if this is possible in access, but if you have a suggesstion please help.

    Thank you

    Thursday, July 18, 2013 9:12 PM

Answers

  • 1. Create a text box for each of your criteria so users can input the number of NumProducts, NumDisciplinary, NumDeliquent etc.

    2. Create a query based on your table and add each field to the query

    3. Add an additional field to the query something like:

        Total:[NumProducts]+[NumDisciplinary]+[NumDeliquent]+etc.

        Sort the Total field by Descending

        Include the Total field in your form

    Thursday, July 18, 2013 11:42 PM