Results of query to appear as currency

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.
arendt73Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:

SELECT *, Format([pInStock]*[pPrice],"currency") AS pTotal FROM Products ORDER BY pPrice ASC;
0
 
arendt73Author Commented:
I had to change the double quotes to single quotes around the word currency and got the results I needed. Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.