How do I change number format?

  • Thread starter Thread starter Steve Brown
  • Start date Start date
S

Steve Brown

I have a tabel that contains numbers like
10001414598
I only want the last 7 digits to display in my report
1414598

How do I do this?
I tried puting the following expresion in the controll
source for the text box but the result displayed in the
report was 0


=Right(CStr(CLng([med_rec_nbr])),5)
 
Try this:
=Right(Str([med_rec_nbr]),7)
The above assuming the table contains Long (integers). If the strings are
alphanumeric text already, just the function right([field],7) should do.
 
Back
Top