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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving the last numbers of a field 3
Moving the last numbers of a field 3
Strip out part of a text field 3
exclude certain data in query 7
Sorting 0
Remove Certain String from Query Field 6
Is this type of Join Possible? 3
Expresion 2

Back
Top