Queries

R

Renetta

Hi,

How do I write an expression reading only the first 8 digits of a 9 digit
account #? Please help with the expression. Thanks.
 
J

John W. Vinson

Hi,

How do I write an expression reading only the first 8 digits of a 9 digit
account #? Please help with the expression. Thanks.
Click to expand...

Put in a calculated field

FirstEight: Left([Account #], 8)

John W. Vinson [MVP]
 
Top