Money formatting 'Reposted'

  • Thread starter Thread starter Jane
  • Start date Start date
J

Jane

I have the same problem. Can someone help?
The correct value in ACC should be 125,25 and not 12.525,00
Thank you

in message
Hi,
I have a form which pulls data from SQL2k.
The currency field in SQL is set to money.
The currency field for the form's field is set to euro with 2 decimal
points.
Data when read with SQLAnalizer, is shown as 125.2500.
Data when read with the form or with Access query, is shown as 12.525,00
euros.
Click to expand...

Which is the correct value?
12.525,00 is a valid currency notation.
 
The setting for money is set to: 123.456.789,00 ?
I believe it's ok.
Any more ideas?
Thank you
 
Back
Top