Rounding up of data

M

Mat

Hi
I have a simple database table that I need to record
amounts that could be in US dollars or GB sterling. My
default for my region is GB Sterling. as I do not want
everything to show as '£'. Therefore, in the table design,
I have set the field properties to Number - with a format
option of 'General Number', and 2 decimal places.
However, when entering data in the field it always rounds
the number up or down - I want to record say 23.45 - and
then I use other methods to distinguish between US$ and
GB£.
Can anyone help on the design to do this ?
Thanks
Mat
 
D

DL

Try Format as standard. ie 3,456.79
General gives 3456.788

Hi
I have a simple database table that I need to record
amounts that could be in US dollars or GB sterling. My
default for my region is GB Sterling. as I do not want
everything to show as '£'. Therefore, in the table design,
I have set the field properties to Number - with a format
option of 'General Number', and 2 decimal places.
However, when entering data in the field it always rounds
the number up or down - I want to record say 23.45 - and
then I use other methods to distinguish between US$ and
GB£.
Can anyone help on the design to do this ?
Thanks
Mat
 
Top