Net Pricing

[Brian Keanie]

Some of my suppliers give me a ListPrice and a Discount from which I can
calculate the NetPrice using a query. Other suppliers give me nothing other
than the NetPrice.

If the NetPrice is to be used in other calculations does this require two
separate "net prices" as in NetPrice1 and NetPrice2. If that is the case how
do you fashion an IF statement to use NetPrice2 when there is no value in
NetPrice1?

Hope this makes sense.

[Arvin Meyer [MVP]]

In a query, create a column like this:

NetPrice: IIf(IsNull([NetPrice1],[NetPrice2],[NetPrice1]))
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"Brian Keanie" <bkfi...@sympatico.ca> wrote in message
news:dkf7f.3848$ki7.1...@news20.bellglobal.com...

[Al Camp]

Brian,
Seems like a problem in terminology....
I would call all prices from Suppliers as the BasePrice,
all discounts as Discount, and the calculated final price as NetPrice.

Now, rather than try to handle two ways of calculating NetPrice, make all
your pricing conform to the same logic.

Using some sample data...
BasePrice Discount NetPrice
10.00 .10 9.00
10.00 .00 10.00

NetPrice would be calculated for all items exactly the same...
BasePrice * (1 - .10) = NetPrice
or
BasePrice * (1 - .00) = NetPrice

Now NetPrice can be handled just like any other calculation in queries or
reports.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Brian Keanie" <bkfi...@sympatico.ca> wrote in message
news:dkf7f.3848$ki7.1...@news20.bellglobal.com...