General discussion

Locked

ACCESS 2003 - Query

By teresa.lanthorn ·
In a select query I have a text field that is 12 characters long that
follows the pattern of 3 numbers, a dash, 4 numbers, a dash, 3 numbers.
Example is 123-4567-001. I want the query to remove the first four and the
last four characters so in the example I would only see 4567. I need this
as the middle four characters are the chronology on how projects are entered
into the system which I need to insure I synch this number with another database. What critieria
do I need to apply or how would I do this. Thank you.

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums