format

[Frank Dulk]

The result of that procedure in a query is 2,50 I want that is 2.50

altod: SeImed([ALTD]is not null;[altd];0)

 

[Michel Walsh]

Hi,


It is 2.5 and it is 2,5 In fact, it is dependant of the Regional
Setting selected by the end user...


Hoping it may help,
Vanderghast, Access MVP

 

[Frank Dulk]

But the problem is that will create a file separate text for a (,) however
it is confusing, for that I need it transforms that comma in a (.)

Hi,


It is 2.5 and it is 2,5 In fact, it is dependant of the Regional
Setting selected by the end user...


Hoping it may help,
Vanderghast, Access MVP

The result of that procedure in a query is 2,50 I want that is 2.50

altod: SeImed([ALTD]is not null;[altd];0)

 

[Michel Walsh]

Hi,



The easier way is to use the function Replace.


Vanderghast, Access MVP

But the problem is that will create a file separate text for a (,) however
it is confusing, for that I need it transforms that comma in a (.)

Hi,


It is 2.5 and it is 2,5 In fact, it is dependant of the Regional
Setting selected by the end user...


Hoping it may help,
Vanderghast, Access MVP

The result of that procedure in a query is 2,50 I want that is 2.50

altod: SeImed([ALTD]is not null;[altd];0)