format

F

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)
 
M

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
 
F

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 (.)

Michel Walsh said:
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 said:
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)
 
M

Michel Walsh

Hi,



The easier way is to use the function Replace.


Vanderghast, Access MVP


Frank Dulk said:
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 (.)

Michel Walsh said:
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 said:
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)
 
Top