cutting last digits

[Pjero Nizeteo]

Hi there!

I want to make a query field that WILL NOT SHOW last 6 digits of a number
stored in a field with 15 and 16 digit numbers.

Thanks for help
Petar

 

[Douglas J. Steele]

When you say they're 15 or 16 digit numbers, I'm assuming they're actually
stored as text (since there's no data type that will let you accurately
store that many digits).

Left([TextNumber], Len([TextNumber]) - 6) will give you all but the last six
digits.