SQL Format for Sum

[yagerlegi]

Hello,



I have a form that provides the amount paid when a client name is selected. The problem is when the sum displays in a text box using a sql statement it's not formatting correctly. I want to format the box to add commas when the number is thousands. Here is my sql syntax

SELECT Round(Sum([tblclient].[total])) AS Expr1 FROM tblclient WHERE (((tblpurchase.client)=[forms]![frm_purchased_1]![client]) AND ((
[listpurchased])=[tblclient].[client]));

Thank you

[JoeM]

Open the Form in Design View, select your Text Box and change the Format property to "Standard".

[yagerlegi]

Sorry, it a list box and not a text box. The sql statement will not work with a textbox.

[JoeM]

Why not just do the all the calculations in your query, and make the query the source of your form?

[yagerlegi]

I guess I could have done that but its to late now. I need to complete this project this week. Is there anyway to format the numbers?

[JoeM]

I guess I could have done that but its to late now

Not really. You can change the Record Source of an existing Form pretty easily.