http://www.programmersheaven.com/ Contains the latest posts from the thread 'I need help with a calculated column in sql and formatting' posted on the 'SQL-Server' forum at Programmer's Heaven. en Copyright 2013 Programmers Heaven Sat, 18 May 2013 02:40:20 -0700 Sat, 18 May 2013 02:40:20 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 http://www.programmersheaven.com/images/ph.gif http://www.programmersheaven.com/ 88 31 http://www.programmersheaven.com/mb/sql-server/429779/429779/i-need-help-with-a-calculated-column-in-sql-and-formatting/ Hi there and thanks in advance for your help.<br /> <br /> I have a table with an amount and rate columns.<br /> <br /> I am creating a view based on this table and I want to add a calculated column that will provide the result between the amount and the rate columns.<br /> <br /> SELECT dbo.Invoices.Amount, <br /> dbo.Invoices.TransactionRate, <br /> dbo.Invoices.Amount * dbo.Invoices.TransactionRate AS Trans_Amt<br /> FROM dbo.Properties <br /> <br /> The query and the creation of the Trans_Amt column works fine.<br /> <br /> The problem is that the calculated column has too many decimal places and I do not know how to format the calculated column to show only 2 decimal places.<br /> <br /> I am using Access as the GUI <br /> <br /> Regards<br /> <br /> Rio<br /> <br /> <br /> http://www.programmersheaven.com/mb/sql-server/429779/429779/i-need-help-with-a-calculated-column-in-sql-and-formatting/ Wed, 10 Oct 2012 13:29:25 -0700 SQL-Server