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.
 
You must log in or register to reply here.

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 'Reposted' 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
Currency symbol question 6
Setting the format property on a subform 4
Format to Euro instead of Dollar 8
Access 2007 and SQL Server Decimal Datatype 4
custom currency symbol independent of regional settings 1

Back
Top