Removing part of case number

D

DrEvil

Hi,
I have about 22000 cases in database which I would like to reformat. The
case numbers look like this ###-####### , what I would like to do is only
remove first 3 digits after a dash and leave the rest so the format would
look like this ###-#### , the first 3 digits after dash are always zeros (not
sure if that makes any difference). The field is formated as text.
 
R

Rick B

Make an update query and update it to...

Left([SomeFieldName],4) & Right([SomeFieldName],4)
 

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

Page numbering with Merged Document and IF statements 1
Problem with MS Word paragraph and character styles: format getting messed up 2
Finding the proper style field and the numbered paragraph value within the style 0
Using heading level style in the paragraph 3
Update query to format part numbers 3
Removing dashes from a number 5
Text Formats 4
Combobox filtering 2

Top