Currency query

[sdc1234]

Greetings
I have this script that creates a column in my table called s/b, how can I format this script to show up as currency.
RSV S&B: Sum([Per Capita Spent]![Salary])


v/r
Novice

[lfpm062010]

You can use format to show up as currency.

For example:

Format ("1267.5", "Currency")

would return '$1,267.50'

[sdc1234]

You can use format to show up as currency.

For example:

Format ("1267.5", "Currency")

would return '$1,267.50'

perfect thanks