Remove Left Characters up to the first space

[Guest]

I have a field that I need to remove the characters up to the first space.
How do I do this.

123 XXXXXX
2459 XXXXXX
5690 XXXXXXX

 

[Van T. Dinh]

Use

Mid([YourField], InStr([YourField], " "))

 

[Douglas J. Steele]

That'll leave the blank. To remove the blank, use

Mid([YourField], InStr([YourField], " ") + 1)


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Use

Mid([YourField], InStr([YourField], " "))

--
HTH
Van T. Dinh
MVP (Access)

I have a field that I need to remove the characters up to the first space.
How do I do this.

123 XXXXXX
2459 XXXXXX
5690 XXXXXXX

 

[Van T. Dinh]

Good pick-up, Doug.