Need helping removing a blank space...

[meishi85]

I have a custom query column with the following information:

Email:"store" & Right([Company_Name],5) & "@sunny.com"

When I run the query, I see the following:

store 5001@sunny.com
store 5090@sunny.com
store 5022@sunny.com

How can I get rid of the spaced between the "e" from store and the first digit of the store number??

 

[dhookom]

Why are you specifying Right( ,5) when you want Right( ,4)? Am I missing something?

In the event that I missed something obvious, consider using the Trim() function.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[HandsOnAccess]

Use Trim Function, It will remove space.

"store" & TRIM(Right([Company_Name],5)) & "@sunny.com"

Regards,