I have a text box on a report, based on a text box on a form where the user types in the data to show on the report.
The data is a 6 digit number. Example: 200403
I would like the report to show only the first 4 digits of the 6 digit number.
I have been trying different formats with no success.
thanks
The data is a 6 digit number. Example: 200403
I would like the report to show only the first 4 digits of the 6 digit number.
I have been trying different formats with no success.
thanks