money field in mssql


D

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
 
Ad

Advertisements

S

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.
 
Ad

Advertisements

D

Danny Nielsen

Steve Jorgensen said:
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

Thanks alot. Got messed up I guess ! :)

Danny Nielsen
 

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

Top