Need help to write a code/query

[shimul]

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.

[shimul]

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.

[FishVal]

Hello, shimul.

Check, please, this thread.

Regards,
Fish.

[NeoPa]

You may also find http://bytes.com/topic/access/insigh...ltiple-records helpful.

Good luck, and welcome to Bytes!