PDA

View Full Version : [SOLVED:] Access 1997 SQL Format a Calculated Field as Currency


cleteh
07-19-2016, 10:03 AM
([A].[PRIN_AMT]*[INT_RATE]*(1/365.25)*([NumDays])) AS YESTERDAYS_INT_Calc

How do I format that as currency?

Thank you
cleteh
07-19-2016, 04:44 PM
In Access open in design view, right click on the field, select properties, select format, select currency or any other data type