[AccessD] Access rounding scenario

So the components are (air code):

Select Amount
>From Details
Where Item = "Transport" / (Select Count(*) Where Item <> "Transport")
As LeveledTransport

I didn't try to run it but that should be close to what you need. Add that
as a calculated column in your query.

Arthur

On Mon, Aug 22, 2011 at 10:13 PM, Lawrence Mrazek <lmrazek at lcm-res.com>wrote:

> Yes, a bit screwy when you think of it this way, but these are the specs
> ...
> they want to see the transport charge with the material line item, instead
> of a line item by itself.
>
> Thanks to all for  the feedback!
>
> Larry Mrazek
> lmrazek at lcm-res.com
> ph. 314-496-1645
>
>