Calculated column format

[SimonPGreen]

Hi,

Have a calculated column for VAT that I am opening in a Datasheet. Is it possible to format this to currency i.e. round to two decimal places, show £ and .00 at the end even if integer?

Regards,

Simon

 

[AlexCuse]

Yes, have a look at the FORMATCURRENCY function.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[SimonPGreen]

Alex,

Thanks - unfortunately my first post was wrong - I am displaying the results of a query. Not displaying a form in datasheet view.

It appears that formatcurrency is not a function supported in Jet SQL?

Regads,

Simon

 

[AlexCuse]

What version of access are you using? Formatcurrency works fine for me (2k3).

Here's how it is called:

FormatCurrency(Expression, DecimalPlaces)

Where decimalplaces is an integer of course.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[SimonPGreen]

Alex,

Apologies - I was using CurrencyFormat()

Thanks for the post.

Simon

 

[AlexCuse]

Hehe, that'll get ya every time ;-)

Glad it helped

Ignorance of certain subjects is a great part of wisdom