weight calculation

From: Terje (terje_at_cyberfactory.no)
Date: 11/07/04 

Date: Sun, 7 Nov 2004 13:32:10 +0100

I'm stuck with a problem, and I think its easy solved for a clever mind :)

I have a page where something like this is listed out from a session

Product A costs 56 -weight 4,5 - Supplier 2
Product B costs 58 - weight 1,5 - Supplier 1
Product C costs 37 - weight 3,1 - Supplier 2 and so on.

Is there anyway I can summarize the weight on each supplier, example the
total weight for products from supplier 2 is 7,6?

I was wondering about use of array or something but are unable to see a good
working solution, as the number of suppliers are different so I can't use
stuck variables as weightsupplier1 and so on.

Terje

Relevant Pages

  • RE: what to use
    ... E contains the name of supplier, this supplier have sent xx shipments to us ... The first supplier in E2 is Mini press, and in K the weight is 80 then I ... where the result from the transporters report will get ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Relational query with path expressions
    ... pounds or are supplied by supplier S2 or both. ... I think equivalence of these depends on a FK constraint from SP.P# to ... asterisk expands into all the attribute names from the input relation. ... P(*(-COLOR, WEIGHT as W), SP.S.SNAME) ...
    (comp.databases.theory)
  • Re: Best Practice for tables?
    ... use the ID or Primary Key value.The tblRoutingSystem should ... Now if the Supplier decides to sell the company or change its name, ... Now, as dispatch of items are dependent on the weight, I have another ... 'DispatchMethod' which refers to 'tblDispatchMethod' ...
    (microsoft.public.access.gettingstarted)
  • Re: Update Query based on a value between two fields
    ... UPDATE TableA INNER JOIN TableB ... with TableA supplier and weight and table b supplier. ...
    (microsoft.public.access.queries)
  • Re: Blizzard emergency!
    ... Not only does the weight improve the traction, if you get stuck ... cat owner. ... Another variation is to carry a few sacks of dry cat food. ...
    (rec.arts.sf.fandom)