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

Concatenation

P: 1
Suppose in the field of a column there is a value as

I am
a good and
nice guy.

I would like to make it appear as I am a good and nice guy by writing a query. Now the content is dynamic and may change. So how do I write the query to concatenate so as the query understands that "m" is the last entry and the next on should be "a" and it should be displayed along with the space after "m". Hope am clear.
Sep 26 '07 #1
Share this Question
Share on Google+
1 Reply


FishVal
Expert 2.5K+
P: 2,653
Suppose in the field of a column there is a value as

I am
a good and
nice guy.

I would like to make it appear as I am a good and nice guy by writing a query. Now the content is dynamic and may change.
Write VBA function concatenating records, retrieved to Recordset.

So how do I write the query to concatenate so as the query understands that "m" is the last entry and the next on should be "a" and it should be displayed along with the space after "m". Hope am clear.
You need an additional field storing text part sequential number.
Sep 26 '07 #2

Post your reply

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