Atribute values by position on Query...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Roy (Roy_at_discussions.microsoft.com)
Date: 07/20/04 

Date: Mon, 19 Jul 2004 23:33:01 -0700

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...

Relevant Pages

  • Re: Access combo box-show name, not ID, in table?
    ... > there a better way to link to the Supplier Table that I'm missing? ... Put another way, why duplicate the table with a query, if I ... Those queries need to be left join queries.. ... I understand the norm is to then store the Supplier ID ...
    (microsoft.public.access.gettingstarted)
  • Re: Opposite Not In List
    ... The Control Source of the combo box should simply be SELECT ToolID, ToolName ... Your query is hiding data: any tool that isn't yet assigned to a job won't ... the Supplier when you try to add the new Tool to the Tools table. ... Dim sTitle As String ...
    (microsoft.public.access.formscoding)
  • Re: Simple query??
    ... If the names were changed to PracticeSuppier for the table and AutoCategory for the field then the query would look like the following. ... , AUTO CATEGORY ... GROUP BY SUPPLIER; ... SELECT DISTINCT [practice suppliers].SUPPLIER ...
    (microsoft.public.access.queries)
  • Re: Access combo box-show name, not ID, in table?
    ... there a better way to link to the Supplier Table that I'm missing? ... Put another way, why duplicate the table with a query, if I can ... Those queries need to be left join queries.. ... but I have to ask: If the normal and recommended way is to store ...
    (microsoft.public.access.gettingstarted)
  • Re: "pivoting" data with a querry
    ... I created a make table query from the Sage Line100 ODBC datasource (had to ... ODBC datasource) I then created a union query to normalise the table as you ... then created a select query to filter out the ItemNumber I ... > SELECT ItemNumber, Supplier1 as Supplier, 1 as SupNum ...
    (microsoft.public.access.queries)