SQL Number format

[yagerlegi]

Hello,

I am currently using sql syntax to get the data from a table on a form. I have a list where it sums up all the sales for that particular customer but I need help formatting the number. Here is my statement

SELECT (SUM([tblsales.sale])) from tblsales WHERE tblsales.id=forms!frm_Sales.Customer;

How do I add a format to this syntax? I would like to format the number with commas and no decimal.

Thank you,

[June7]

Try the FormatNumber() function.

FormatNumber(Sum([sale]),2) AS SumSales

Otherwise, build a report and set Format and DecimalPlaces properties of textbox.