SYNTAX
The syntax for the Format function in MS Access is:
Format ( expression, [ format ] )Format (210.6, "#,##0.00")
Result: '210.60'
Format (210.6, "Standard")
Result: '210.60'
Format (0.981, "Percent")
Result: '98.10%'
Format (1267.5, "Currency")
Result: '$1,267.50'
contoh :
Format(DSum("mutasi","query2","idkartustok <=" & [idkartustok]),"Currency") AS Saldo
