R
Roy
Got a supplier and a product table..
i Made a query were Each Supplier got an average of the performance on each product...(ex: Ellesmere - Mince 95VL - 94%
Perth - Mince 95VL - 93%
Ellesmere - Mince 90VL - 85%)Etc...
After, I Slit the Query in Products(Each Query 1 Product)
Now i Have a Query with the performance of all supplier for 1 product, witch if i order "Ascending by performance" give the "Table League" for that product. Where the first Supplier in the top of the query is the best supplier for that product(I hope u Understand)
Now What i Want is on the Query input 1 Column that give a Score to the supplier, by line. Soo the Supplier on the first line is No 1. Supplier on Second line is No 2...etc.
The Reason Why is At the End i Will get all scores from all products, and see witch Supplier is the best(get more high scores)
There's No Table built to Keep the scores, but im open to New Ideias. if u know a best way to do this Operation in a Form go on.
Thank u...
i Made a query were Each Supplier got an average of the performance on each product...(ex: Ellesmere - Mince 95VL - 94%
Perth - Mince 95VL - 93%
Ellesmere - Mince 90VL - 85%)Etc...
After, I Slit the Query in Products(Each Query 1 Product)
Now i Have a Query with the performance of all supplier for 1 product, witch if i order "Ascending by performance" give the "Table League" for that product. Where the first Supplier in the top of the query is the best supplier for that product(I hope u Understand)
Now What i Want is on the Query input 1 Column that give a Score to the supplier, by line. Soo the Supplier on the first line is No 1. Supplier on Second line is No 2...etc.
The Reason Why is At the End i Will get all scores from all products, and see witch Supplier is the best(get more high scores)
There's No Table built to Keep the scores, but im open to New Ideias. if u know a best way to do this Operation in a Form go on.
Thank u...