Round Function without attachment
Have you tried the EuroConvert() function? I haven't used it myself, but
from what I remember reading in the help file, I think it should do the
rounding for you as well as the conversion.
--
Brendan Reynolds
Access MVP
Sample Access 2000/2002 app at
http://brenreyn.brinkster.net
----------------------------------------
If it's not plain text, without attachments,
I'm not reading it.
----------------------------------------
Quote:
> Sorry everybody for the attachment posted yesterday !!!!
> Hello everyody , please can you tell me how to use the function Round with
> Euro format ?
> I've tried to use the function Round with them , but it doesn't work in a
> proper way :
> a number such as 144.177,00 * 0,005 (0,50%) = 720,88(5) --> must be
> rounded to
> 720,89 according to the euro rounding rules .
> I'm using Access 2000 and it should work as described in the following
> microsoft faq : Q210564 with the currency values like euro one .
> Can you show me a small example , a VB code example please ?
> Or just explain the reason why it doesn't work correctly with the function
> round ?
> Shall I change my international settings in Windows 98 ?
> I'm from Italy and the current value is still set to (LIT) but in Access
> all numeric fields
> are converted into value ones , standard , 2 decimals.
> Gattone
