By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,706 Members | 1,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,706 IT Pros & Developers. It's quick & easy.

Simple concatenation

P: 16
I know I've done this before, but for some reason the answer alludes my brain this Monday morning...

When I concatenate two number fields line:[system] & [sequence], it is dropping the leading zeros.

ex: system = 72 and sequence = 001
concatenate as line:[system] & [sequence= 721

I want to see line = 72001

Jun 11 '07 #1
Share this Question
Share on Google+
3 Replies

P: 16
Now I remember.

Line: [System Number] & Format([Seq No],"000")
Jun 11 '07 #2

P: 52
Glad you got things figured out!

Jun 11 '07 #3

Expert Mod 15k+
P: 31,770
Now I remember.

Line: [System Number] & Format([Seq No],"000")
Two further issues that MAY need to be considered.
  1. [System Number] may need Format()-ing too.
  2. If either value can be a null and you want a string expression returned anyway - use '+' instead of '&'
Jun 11 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.