How to eliminate the zeros ?

[rajrev]

Hi,
problem with the numbers.
In a xx table we have 2 number fields called
From_month, From_Year.
I tried to concadinate these two fields in a formula (@yy)
like cstr(From_month)+"/"+cstr(From_year) and include the formula in the detail section.
I got the result like 2.00/2000.00. But i need 2/2000.
Thanks in adv.
MK

 

[synapsevampire]

Try:

totext(From_month,0)+"/"+totext(From_year,0,"&quot

-k

 

[kchaudhry]

Rajrev,

You can also format the field to show no decimal values.

Kchaudhry

 

[synapsevampire]

Kchaudhry: That won't work, read the post, it's a concatenation, not a field being shown.

-k

 

[rajrev]

Thanks -k. It's working.
MK