Hello. I need to truncate a number in a report. I know that the TRUNC

function works in a worksheet but is there a way to truncate a number in

design mode of a report?

 

Right now I have the field has a fixed number. While that works for display

purposes, when I use the field in a calculation the entire number is

used.....

 

Thanks in advance for your help!

 

Cheers.

Alex

Depending on what part of the number you need, use the Left, Right or

Mid functions to get just a part of the number.



Richard Lobel