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!