need help with report display 1

[TruthInSatire]

Ok... I'm not an access person, but we have a customer who needs something in access... anyway...

we have 3 tables.

table1
  autoNumberID,
  partNum,
  structNum

table2
  autoNumberID,
  table1ID,
  ref1,
  ref2

table3
  autoNumberID,
  table1ID,
  ref3

the report they want should look like this:

PartNum-structNum
-------------------------------------------------
ref1, ref1, ref1, ref1, etc...
-------------------------------------------------
ref2, ref2, ref2, ref2, etc...
-------------------------------------------------
ref3, ref3, ref3, ref3, etc...
-------------------------------------------------

next partnumber
|
|
|
v
last  part number.

we can get the data to display like this:

PartNum-structNum
-------------------------------------------------
ref1
ref1
ref1
ref1
etc...
-------------------------------------------------
ref2
ref2
ref2
ref2
etc...
-------------------------------------------------
ref3
ref3
ref3
ref3
etc...
-------------------------------------------------

how do we get the ref1, ref2, and ref3 to appear as a comma delimited list? I've found a post in TT on creating a module to do it, which i understand, but when/how do i use it?

Thanks for the help.


We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[PHV]

Have a look here: faq701-4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TruthInSatire]

awesome, thanks.

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.