Eliminating multiple infomation in a report?

[Guest]

I think this is a pretty easy solution, just don't know it. I have a report
I'd like to pull from a query that I built from multiple tables. In each
field the information is the same (from one table), with the exception of one
field of changing information (from another table). Because I'm bad at
explaining, I'll give a visual. For example, below is what is displaying in
the query now:

Date Time Location Attendee
6/6/06 10am USA JR Schwartz
6/6/06 10am USA Allie Snow
6/6/06 10am USA Kelly Cay

I want the report to look like this however (below), and I know without some
adjusting somewhere, the report will just print out what I have in the query
above repeating the date, time and location:

Date Time Location Attendee
6/6/06 10am USA JR Schwartz, Allie Snow, Kelly Cay

I belive that I need to adjust something in a second query before I build a
report, but I'm just not sure what to do. Any help is greatly appreciated.

Thank you!
-Valerie

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/modules/mdl0004.htm or
http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web"

 

[Duane Hookom]

or, the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. The link
has a sample database you can run to see how to use the function.

 

[Marshall Barton]

I think this is a pretty easy solution, just don't know it. I have a report
I'd like to pull from a query that I built from multiple tables. In each
field the information is the same (from one table), with the exception of one
field of changing information (from another table). Because I'm bad at
explaining, I'll give a visual. For example, below is what is displaying in
the query now:

Date Time Location Attendee
6/6/06 10am USA JR Schwartz
6/6/06 10am USA Allie Snow
6/6/06 10am USA Kelly Cay

I want the report to look like this however (below), and I know without some
adjusting somewhere, the report will just print out what I have in the query
above repeating the date, time and location:

Date Time Location Attendee
6/6/06 10am USA JR Schwartz, Allie Snow, Kelly Cay

I think this a one of the better functions to do that:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

 

[Guest]

Hi everyone, thanks for the help. DUANE, I tried your example and typed in
the Concatenate function but received an error message of "Undefined function
'Concatenate' in expression", when I clicked on help for a description it
stated:

You entered an SQL expression that includes a Function procedure name that
cannot be recognized. Make sure the function exists, that it can be used in
SQL expressions, or check the expression to make sure you entered the name
correctly.

It seems like it's not recognizing 'Concatenate'?????

 

[Duane Hookom]

You would need to add the module containing the function to your MDB. You
can import it or copy and paste the code into an existing or new module.