| | |
|
|
|
Access multiplying SQL data x 100?? |
|---|
| message from Jerome on 06 May 2004 |
Hi,
I've still got this problem that Access 2000 multiplies the decimal and
currency values from my SQL Server database x 100! Both in the linked
table view and one the forms.
Anyone got any idea what the problem could be? The regional settings on
both the server and my PC are the same, so no problem there?
The field in the SQL database is DECIMAL, in Access it's displayed as
Number/Decimal resp. MONEY on SQL and Currency in Access.
Are decimal and currency the only datatypes in SQL that allow fractions?
Is DOUBLE in Access DECIMAL on SQL?
Any help is greatly appreciated!
Jerome
Jerome wrote:
|
| david epsom dot com dot au replied to Jerome on 10 May 2004 |
Access supports both SINGLE and DOUBLE data types, which
allow ordinary (floating length) fractions. SQL Server has
identical types. 'Decimal' is not well supported in Access,
and not even very well supported in ODBC.
Apart form Decimal and Currency, Access has no other
fractional fixed-length, decimal, or symbolic types, although
they can by simulated by text fields.
(david)
"Jerome" <jherr@no.mnhn.spam.lu> wrote in message
news:OGKXkA1MEHA.556@tk2msftngp13.phx.gbl...
|
|
Archived message: Access multiplying SQL data x 100?? (Microsoft Access Database)
