report printing columun

  • Thread starter Thread starter jale
  • Start date Start date
J

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
 
jale said:
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..
Click to expand...

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
 
Back
Top