delete excess numbers

M

Michel Walsh

Hi,


And to remove the first zero of each sequence, before the
"agglutination":


? Val( Replace("0344 0062 012 0000", " 0", "") ) /1000


assuming Access 2000 or later, and that the last sequence is always four
zeros.



Vanderghast, Access MVP
 
V

Van T. Dinh

Thanks for catching that, Michel.

I read quickly and thought that the O.P. meant the *very* first zero.
 

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

How to delete excess page 1
trying to run qurry using zoom and it wont work 1
Delete all data after a symbol in a field 0
Outlook Express 0
Query truncating memo field 2
Problem with multi join query 1
Finding records whose ID is NOT IN another record set 0
How many if statements can be nested together? 0

Top