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,