report printing columun

[jale]

Hi

I have tables and queries about delivery product and reports for delivery
notes and packing notes.There is a lot of packing note number for one
Delivery note number.
If I would have a packing note number for a Delivery note number ,life is
very easy.

Is it possible to see all Packing note number with coma or " -" or " from
number -to Number" on a Delivery report.

Table sample is:

P.N.N D.N.N
5 3
5 3
6 3
9 3
9 3
9 3

Shown:5,6,9 or 5-6-9 or if it would be sequence 5-7..

Thanks for your help.

Jale

 

[Marshall Barton]

I have tables and queries about delivery product and reports for delivery
notes and packing notes.There is a lot of packing note number for one
Delivery note number.
If I would have a packing note number for a Delivery note number ,life is
very easy.

Is it possible to see all Packing note number with coma or " -" or " from
number -to Number" on a Delivery report.

Table sample is:

P.N.N D.N.N
5 3
5 3
6 3
9 3
9 3
9 3

Shown:5,6,9 or 5-6-9 or if it would be sequence 5-7..

This will take some code in a function to gather and format
the sequence. For an example see Duane Hookom's Generic
Function To Concatenate Child Records at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

 

[jale]

Thanks.I will try it..

This will take some code in a function to gather and format
the sequence. For an example see Duane Hookom's Generic
Function To Concatenate Child Records at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane