cutting last digits

  • Thread starter Thread starter Pjero Nizeteo
  • Start date Start date
P

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
 
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.
 
Back
Top