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

Need help to write a code/query

P: 28
Hi All,

Have query where I get the result like (except "-------------------",put it to separate the two columns)

NUMBER ---------------TYPE DESCRIPTION
17 --------------------------Basic
17 --------------------------Basic
17 --------------------------Actions
17 ---------------------------Conditions
17 ----------------------------Factors
18 ----------------------------Basic
18 ---------------------------Actions
19 ------------------------------so
19 ------------------------------so
so on …….

But would like result following way

NUMBER ----------------TYPE DESCRIPTION
17 ----------------------------Basic| Basic| Actions| Conditions |Factors
18 ----------------------------Basic| Actions
19 ------------------------------so|so
so on…….

Is the anyway I can get my desire result?
If possible give code or example.

Thank you.
Shimul

Note: If question is not clear please check the attachment.
Dec 12 '08 #1
Share this Question
Share on Google+
3 Replies


P: 28
OR

Hi All,

Have query where I get the result like (except "-------------------",put it to separate the two columns)

NUMBER ---------------TYPE DESCRIPTION
17 --------------------------Basic
17 --------------------------Basic
17 --------------------------Actions
17 ---------------------------Conditions
17 ----------------------------Factors
18 ----------------------------Basic
18 ---------------------------Actions
19 ------------------------------so
19 ------------------------------so
so on …….

But would like result following way

NUMBER ----------------TYPE DESCRIPTION
17 ----------------------------Basic, Basic, Actions, Conditions ,Factors
18 ----------------------------Basic,Actions
19 ------------------------------so,so
so on…….

Is the anyway I can get my desire result?
If possible give code or example.

Thank you.
Shimul

Note: If question is not clear please check the attachment.
Dec 12 '08 #2

FishVal
Expert 2.5K+
P: 2,653
Hello, shimul.

Check, please, this thread.

Regards,
Fish.
Dec 13 '08 #3

NeoPa
Expert Mod 15k+
P: 31,494
You may also find http://bytes.com/topic/access/insigh...ltiple-records helpful.

Good luck, and welcome to Bytes!
Dec 18 '08 #4

Post your reply

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