money field in mssql

[Danny Nielsen]

Ho out there

I'm using mssql and Access 2000 as front-end. My problem is that the
application I'm developing is goint to be used in both Denmark, Polen and
England. Therefore, one of my fields(type money) should be able to consist
of both the danish kroner (kr) and £ money types. Im developing the
application on a citrix server and depending on whether I set the regional
settings (Windows) on this citrix server to Danish or English, the field
changes accordingly to this. I want to be able to put in both kr and £
depending on the users choise.
Is this possible or do I have to make the field a float-field and use
another field to let the user choose between kr and £?

Thanks in regards

Danny Nielsen

 

[Steve Jorgensen]

A Money field is simply money. The currency symbol can be anything yuo want,
but it has no effect on what is stored, that's just a number. If you need to
know the difference between currency types after they are entered, you will need
another column to indicate the type. Do not use float to store money data, it
is not suitable. Instead, continue to use Money, but set the formatting to
General Number so that no currency symbol appears in the controls bound to the
field.

 

[Danny Nielsen]

A Money field is simply money. The currency symbol can be anything yuo want,
but it has no effect on what is stored, that's just a number. If you need to
know the difference between currency types after they are entered, you will need
another column to indicate the type. Do not use float to store money data, it
is not suitable. Instead, continue to use Money, but set the formatting to
General Number so that no currency symbol appears in the controls bound to the

field.

Thanks alot. Got messed up I guess !

Danny Nielsen