MySQL Forums
Forum List  »  Microsoft Access

Currency and Deciamal with Microsoft Access
Posted by: Michael
Date: July 30, 2004 03:45AM

Hi,

i'm having a little problem over here...

I've got an exported Data-File.
It's data is separated with semicolons ";"
This file is written with a VB6.0-Program into a MS-Access-Database...
The Problem now is the Price-field.

The data in the Price-Field look like this:

7 -> means 7 bugs
7.5 -> means 7.50 bugs
7.95 -> means 7.95 bugs
59.39 -> means 59.39 bugs

not very strange, is it?

but what is that MS-Access-SQL-thing doing?

if i set the Price-Field as "currency" it makes

7 -> 7,00 bugs -- That's ok....
7.5 -> 75,00 bugs -- From here it's not OK anymore...
7.95 -> 795,00 bugs
59.39 -> 5939,00 bugs

and so on.....

if the Price-field is set to a float data-field i get something like

7 -> 7
7.5 -> 75
7.95 -> 795
59.39 -> 5939

it just cuts away the decimal......

i really despair on that problem..

however: I was not able to write an SQL-Statement that makes a float-Field with 2 decimal-positions... and i nearly searched the whole Internet for it....

in oracle-SQL it works like that: "price_field number(8,2) not null,"
but how does that work in MySQL... especialy in MS-Access-MySQL?

PLEASE, CAN ANYBODY HELP ME?
Thanks to all

greets
Michael

Options: ReplyQuote


Subject
Views
Written By
Posted
Currency and Deciamal with Microsoft Access
8006
July 30, 2004 03:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.