Currency and Deciamal with Microsoft Access

[Michael]

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