Money formatting

  • Thread starter Thread starter Rosa
  • Start date Start date
R

Rosa

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.
What am I missing?
TIA
Rosa
 
Rosa said:
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 correct value is 125,25 euros.
Excel when pulls data from the same source read it fine, 125,25 euros.
However, ACC reads it 12.525,00 euros which is quite different.
Thank you.
 
Back
Top