Posted by Erich93063 on 01/11/06 20:13

I am trying to query a table of items There is a field for the name of
the item, price, quantity etc. When I query I would like to return a
"total price" which would be price * quantity and alias it out as
"Total". So something along the lines of:

SELECT vchrItem,
monPrice,
intQuanity,
(monPrice * intQuantity) AS Total,
...
FROM ...
WHERE intTableID = 12345

Obviously thats NOT how you do it but that is what I am trying to do. I
NEED this to come out in the query as I cannot calculate this
afterwards. The total value needs to be part of the recordset.

THANKS!!

[Back to original message]