Hi there and thanks in advance for your help.
I have a table with an amount and rate columns.
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.
dbo.Invoices.Amount * dbo.Invoices.TransactionRate AS Trans_Amt
The query and the creation of the Trans_Amt column works fine.
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.
I am using Access as the GUI