S
Simon Harris
Hi All,
I am writing a report in Access 2003 which is for invoicing. I need to
display a currency value, but this needs to be displayed in two seperate
boxes - One for pounds and one for pence, both seeded from the same table
column. The table column has a currency data type.
I have two problems:
1) Using this code: =Round(CCur(InvoiceTotal),2) brings back 0.3 - I would
like this displayed as 0.30 (30 pence)
2) Can anyone recommend a way of splitting the pounds and pence values? I
did think about using Split (Not tried yet) but then how would I tell Access
what element of the array that I need?
Any help will be much appreciated.
Thanks!
Simon.
--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
I am writing a report in Access 2003 which is for invoicing. I need to
display a currency value, but this needs to be displayed in two seperate
boxes - One for pounds and one for pence, both seeded from the same table
column. The table column has a currency data type.
I have two problems:
1) Using this code: =Round(CCur(InvoiceTotal),2) brings back 0.3 - I would
like this displayed as 0.30 (30 pence)
2) Can anyone recommend a way of splitting the pounds and pence values? I
did think about using Split (Not tried yet) but then how would I tell Access
what element of the array that I need?
Any help will be much appreciated.
Thanks!
Simon.
--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!