Format 1.34.36.12 to 01343612

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does any on know how to format 1.34.36.12 to look like 01343612
I tried: Format([source],"00000000") in Access with no resolute.
 
Does any on know how to format 1.34.36.12 to look like 01343612
I tried: Format([source],"00000000") in Access with no resolute.
Click to expand...

If your version of Access supports the Replace function:

=Format(Replace([Source],".",""),"00000000")
 
Thank you very much, Kevin


fredg said:
Does any on know how to format 1.34.36.12 to look like 01343612
I tried: Format([source],"00000000") in Access with no resolute.
Click to expand...

If your version of Access supports the Replace function:

=Format(Replace([Source],".",""),"00000000")
Click to expand...
 
You must log in or register to reply here.

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

Text format 1.34.36.12 to look like 01343612 5
Dell Optiplex graphics driver failure 2
Excel Highlighting duplicates 0
Repair a front end DB from another DB 6
How to export reports to html format automatically 0
Text to date format? 0
Word Pointing Different Citations to Same Source 0
Format undefined 2

Back
Top