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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Money formatting 2
Currency designations 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Form Refresh 1
Setting the format property on a subform 4
custom currency symbol independent of regional settings 1
Currency symbol question 6
changing multiple records with a combo box. 1

Back
Top