self concatenation

[mohammadagul]

H ow to concatenate the records of a single field with iteself
forexample

invoice no:
1
2
3
4
5
...

i want it to be written as
1,2,3,4,5,6

can it be done
can i concatenate records with each other of the same field.

 

[mohammadagul]

anything
anyhelp....

 

[WayneRyan]

mohammadagul,

You're going to need to use a simple recordset. MS has a Knowledge Base
article on this, but I don't know the link.

You can look in the Sample Database Forum. I posted one that is
titled something like "Parent/Child Records". It should be enough to get
you started.

Wayne

 

[NPUser]

check this multiselect listbox exmple. It will point you to right direction. http://www.access-programmers.co.uk/forums/showthread.php?t=72319