Formatting with commas

U

user

Howdy!

I have a report that shows a numeric field called Gross weight in Kg. ex:
5.75
6.31
etc.

I need to create a report of the same field in this format:
5,75
6,31
etc.

I need to replace the 'period' with 'comma', is there a way of doing this
using the control source of the field?

TIA!
 
U

user

Thank you for your response Ofer.

I put the following in the control source =Replace([Wt-Kg],".", ",") but
it gave me syntax error.

Ofer said:
Try using replace function

=Replace([FieldName],".",",")


user said:
Howdy!

I have a report that shows a numeric field called Gross weight in Kg. ex:
5.75
6.31
etc.

I need to create a report of the same field in this format:
5,75
6,31
etc.

I need to replace the 'period' with 'comma', is there a way of doing this
using the control source of the field?

TIA!
Click to expand...
Click to expand...
 
O

Ofer

If the field name in the report is also Wt-Kg change it to something else, in
that case it shouldn't have the same name as the field in the table.


user said:
Thank you for your response Ofer.

I put the following in the control source =Replace([Wt-Kg],".", ",") but
it gave me syntax error.

Ofer said:
Try using replace function

=Replace([FieldName],".",",")


user said:
Howdy!

I have a report that shows a numeric field called Gross weight in Kg. ex:
5.75
6.31
etc.

I need to create a report of the same field in this format:
5,75
6,31
etc.

I need to replace the 'period' with 'comma', is there a way of doing this
using the control source of the field?

TIA!
Click to expand...
Click to expand...
Click to expand...
 
U

user

Thank you very much, it worked. I have one more issue, if it's a whole
number, it does not give me the 2 decimal zeros, for ex. 6 and 4,8 should
be 6,00 and 4,80. Thanks again.

Ofer said:
If the field name in the report is also Wt-Kg change it to something else, in
that case it shouldn't have the same name as the field in the table.


user said:
Thank you for your response Ofer.

I put the following in the control source =Replace([Wt-Kg],".", ",") but
it gave me syntax error.

Ofer said:
Try using replace function

=Replace([FieldName],".",",")


:

Howdy!

I have a report that shows a numeric field called Gross weight in Kg. ex:
5.75
6.31
etc.

I need to create a report of the same field in this format:
5,75
6,31
etc.

I need to replace the 'period' with 'comma', is there a way of doing this
using the control source of the field?

TIA!
Click to expand...
Click to expand...
Click to expand...
 
O

Ofer

Try this

=Replace(format([FieldName],"#.00"),".",",")



user said:
Thank you very much, it worked. I have one more issue, if it's a whole
number, it does not give me the 2 decimal zeros, for ex. 6 and 4,8 should
be 6,00 and 4,80. Thanks again.

Ofer said:
If the field name in the report is also Wt-Kg change it to something else, in
that case it shouldn't have the same name as the field in the table.


user said:
Thank you for your response Ofer.

I put the following in the control source =Replace([Wt-Kg],".", ",") but
it gave me syntax error.

:

Try using replace function

=Replace([FieldName],".",",")


:

Howdy!

I have a report that shows a numeric field called Gross weight in Kg. ex:
5.75
6.31
etc.

I need to create a report of the same field in this format:
5,75
6,31
etc.

I need to replace the 'period' with 'comma', is there a way of doing this
using the control source of the field?

TIA!
Click to expand...
Click to expand...
Click to expand...
 
U

user

It works like a charm, thank you so much!!

Ofer said:
Try this

=Replace(format([FieldName],"#.00"),".",",")



user said:
Thank you very much, it worked. I have one more issue, if it's a whole
number, it does not give me the 2 decimal zeros, for ex. 6 and 4,8 should
be 6,00 and 4,80. Thanks again.

Ofer said:
If the field name in the report is also Wt-Kg change it to something else, in
that case it shouldn't have the same name as the field in the table.


:

Thank you for your response Ofer.

I put the following in the control source =Replace([Wt-Kg],".", ",") but
it gave me syntax error.

:

Try using replace function

=Replace([FieldName],".",",")


:

Howdy!

I have a report that shows a numeric field called Gross weight in Kg. ex:
5.75
6.31
etc.

I need to create a report of the same field in this format:
5,75
6,31
etc.

I need to replace the 'period' with 'comma', is there a way of doing this
using the control source of the field?

TIA!
Click to expand...
Click to expand...
Click to expand...
 
O

Ofer

Any time :)

user said:
It works like a charm, thank you so much!!

Ofer said:
Try this

=Replace(format([FieldName],"#.00"),".",",")



user said:
Thank you very much, it worked. I have one more issue, if it's a whole
number, it does not give me the 2 decimal zeros, for ex. 6 and 4,8 should
be 6,00 and 4,80. Thanks again.

:

If the field name in the report is also Wt-Kg change it to something else, in
that case it shouldn't have the same name as the field in the table.


:

Thank you for your response Ofer.

I put the following in the control source =Replace([Wt-Kg],".", ",") but
it gave me syntax error.

:

Try using replace function

=Replace([FieldName],".",",")


:

Howdy!

I have a report that shows a numeric field called Gross weight in Kg. ex:
5.75
6.31
etc.

I need to create a report of the same field in this format:
5,75
6,31
etc.

I need to replace the 'period' with 'comma', is there a way of doing this
using the control source of the field?

TIA!
Click to expand...
Click to expand...
Click to expand...
 
Top