Hi,
In 7.2 we now have 10 digit order numbers etc. We only are using 6 digits currently. Is their a way to stop the extra 4 zeros from showing?
thanks
Ralph
Go into Report Designer and select the form to edit; create a Formula called "Invoice Number", then use the Strings function ie RIGHT(invoice number field, 6) and this will limit the invoice number to the 6 characters starting from the right side