Rounding up of data

[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

 

[Joseph Meehan]

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

If you are only entering two decimals and only adding or subtracting and
displaying the answer in two decimals, there should be no rounding.

 

[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