Tom,
Thank you.
I shall experiment.
> "Harvey, Allan AC" <[EMAIL PROTECTED]> writes:
> > select
> > b.block,
> > b.p_code,
> > p.description,
> > p.blk_speed as "set",
> > blk_speed( b.block ) as "actual",
> > blk_speed( b.block ) / ( p.blk_speed + 0.0001 ) * 100
> as "Spe
"Harvey, Allan AC" <[EMAIL PROTECTED]> writes:
> select
> b.block,
> b.p_code,
> p.description,
> p.blk_speed as "set",
> blk_speed( b.block ) as "actual",
> blk_speed( b.block ) / ( p.blk_speed + 0.0001 ) * 100 as "Speed %"
> from block b, product p
> where b.p_code = p.p_c
