Syntax for multi steps in query

[Tony in Michigan]

Hello,
I'm looking for some help with queries. I would like to combine multiple
steps done with queries into single queries.

example I have a data field with 20 spaces xxx-xxxxxxx-x_nnnnnn
currently, to pull the needed portion, i do 2 steps with an update query,
updating a blank field with the new data.
q1: left([field]),13)
q2: replace([field],Chr(45)"")

How would I combine the steps? Is there a more elegant way of doing this?
I have not graduated to SQL, but given some guideance, I'm willing to go in
that direction.

 

[Sylvain Lafontaine]

Try with: Replace (Left([field],13), Chr(45), "")

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Tony in Michigan]

Merci Sylvain!

It worked perfectly, plus I have already applied the same thought process to
several other multi step queries.

It looks counter intuitive, putting the replace first. I guess that I'll
figure out the subtle nuances over time

Try with: Replace (Left([field],13), Chr(45), "")

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Hello,
I'm looking for some help with queries. I would like to combine multiple
steps done with queries into single queries.

example I have a data field with 20 spaces xxx-xxxxxxx-x_nnnnnn
currently, to pull the needed portion, i do 2 steps with an update query,
updating a blank field with the new data.
q1: left([field]),13)
q2: replace([field],Chr(45)"")

How would I combine the steps? Is there a more elegant way of doing this?
I have not graduated to SQL, but given some guideance, I'm willing to go
in
that direction.