I have a query that multiplies two fields and gives me the correct numerical results. But I want the results (pTotal) to appear in currency format on my webpage. What has to be done?
SELECT *, [pInStock]*[pPrice] AS pTotal FROM Products ORDER BY pPrice ASC;
Any assistance is greatly appreciated. Thank you.