467,923 Members | 1,142 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

"ZH"+Str([MyNumericField]) adds a space

In a query I have this expression:

Expr1: "ZH"+Str([MyNumericField])

It should give me ZH1234 but it adds a space between the 2 parts so I get ZH
1234.

What can I do to prevent this?
Thanks,
john
Aug 30 '06 #1
  • viewed: 2209
Share:
2 Replies
Expr1: "ZH" & Trim(Str([MyNumericField]))
Chris Nebinger
john wrote:
In a query I have this expression:

Expr1: "ZH"+Str([MyNumericField])

It should give me ZH1234 but it adds a space between the 2 parts so I get ZH
1234.

What can I do to prevent this?
Thanks,
john
Aug 30 '06 #2
I already tried something like that, putting the trim after the str, without
results.
But now it works!
thanks
john

<ch************@gmail.comschreef in bericht
news:11**********************@i42g2000cwa.googlegr oups.com...
Expr1: "ZH" & Trim(Str([MyNumericField]))
Chris Nebinger
john wrote:
>In a query I have this expression:

Expr1: "ZH"+Str([MyNumericField])

It should give me ZH1234 but it adds a space between the 2 parts so I get
ZH
1234.

What can I do to prevent this?
Thanks,
john

Aug 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Randell D. | last post: by
12 posts views Thread by Jacob Weber | last post: by
4 posts views Thread by Christoph Haas | last post: by
5 posts views Thread by RetroMIDI | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.