Showing all data in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form for keeping track of container information. This form has a
subform that keeps track of the area that the container contents are held in.
So my subform table has the containerID, an AreaID, and then the Area#. I
need to print out a report that shows the container area and then all of the
area#'s in a row. i.e.
Container 1 (main table) Area's 1, 4, 6, 10 (subform table)
Does anyone know of a way to group all of the records for each particular
container and then cancatenate the information so it will print out the area
information on one line in a report?

Thanks for any help you can give me.
 
I inserted the module from the site that you directly me to and also inserted
the following SQL statement:

SELECT [tblBarge Information].BargeID, fConcatChild("tblBay
Information","BargeID","Bay #","Long",[BargeID]) AS SubFormValues
FROM [tblBarge Information];

with the tblBarge Information being the 1 and the tblBay Information being
the M. The BargeID is the auto# and the Bay # is the data I am looking for.
But when I run my query the SubFormValues field is blank. Any ideas?

Thanks!!
 
Back
Top