MS Access - Query syntax to look up condition

Hi Experts,

I have a field for company name:

The Great Company
The Microsoft Company
The Book Store

I need to write a simple query in Access like:

CompanyName: Iif(Left,3 = The) then
put at end the word The

So it would be like:
Great Company, The
Microsoft Company, The
Book Store, The

Thanks for any help
Amour22015Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mike EghtebasDatabase and Application DeveloperCommented:
A very similar question/answer is posted at:

http://www.experts-exchange.com/Database/MS_Access/Q_28671903.html
Amour22015Author Commented:
It looks like I don't understand and am knew to all this.

I have a field:
CompanyName

In that field I could have some Company names that start with "The" it could also have " The" (with a blank in front of the word "The".
So:
The Great Company
 The Microsoft Company
The Book Store

I am using MS Access 2010
I am doing this in a simple query:
CompanyName: Iif(Left((CompanyName),3)="The" then (Left((CompanyName),-4) & ", The")

I am looking for something like above.  Seems the link pointed out above is too complex for what I am looking for?

Thanks for any help
Rey Obrero (Capricorn1)Commented:
use this

CompanyName:iif(Left([companyfield],3)="The",[companyfield] & ", The",[companyfield])
Rey Obrero (Capricorn1)Commented:
oh sorry try this

iif(Left([company],3)="The",mid([company],4) & ", The",[company])

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Amour22015Author Commented:
Thanks that looks like it
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.