Re: Who yields - client or developer? Your opinion
Date: Sun, 2 Jun 2002 18:55:19 +1000
Message-ID: <adcm9u$1ql$1_at_perki.connect.com.au>
> I'm not sure I followed all this, but I think If you create
> a table with the units in one field and the expression in a
> second field.
> Units QtyFormula
> L/Sq.m/mm [Area] * [Rate] * [Thickness]
> L/Sq/m [Area] * [Rate]
> kg/Sq.m/mm [Area] * [Rate] * [Thickness]
> kg/Sq.m [Area] * [Rate]
> Sq.m/L [Area] / [Rate]
> Sq.m/kg [Area] / [Rate]
>
> then you could Join that to your table/query on the units
> field and calculate the QtyFormula with something like this:
>
> QtyRate: Eval(Replace(Replace(Replace(QtyFormula, "[Area]",
> [Area]), "[Rate]", [Rate]), "[Thickness]", [Thickness]))
>
> Setting up to use a Replace function is different in
> different version of Access. For A97 and earlier, you have
> to write your own, in A2K you have to write a UDF that just
> calls the built in Replace function and in AXP you can just
> use the built in Replace function.
>
> --
> Marsh
Many thanks,
Graham
Received on Sun Jun 02 2002 - 10:55:19 CEST