One row instead of Many 2

[Mr2006]

Hello,

I have two tables Events_tbl and Traveler_tbl. The relationship is one-many. on a monthly basis, I prepare a report for the month events. I want instead of having each traveler's name in one row, I want to be able to group all the travelers in few rows. to be clear, the report now is about 15-20 pages. because one trip may have 8 travelers or more. I want to reduce space andf paper. I want to have the names one after the other example:

Trip to Italy
TravelersJohn Smith, Steve James, Mark Edward)

Right now, it will show like this:
Trip to Italy

Travelers:
John Smith
Steve James
Mark Edward

Can this be done?

Thanks

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Mr2006]

I looked at it and it gave me an idea but I am not sure how can I make it work.

The child record in my table is ProjectActID and the traveler name is TravelerID. The forign key is eventID in projectact_tbl.

Any hyelp will be appriciated

 

[dhookom]

Simply create queries that mirror the tables in the sample. There is an example of usage at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Duane
Hook'D on Access
MS Access MVP

 

[Mr2006]

dhookom ,

Thank you so much. I copied the same codes and I got a an error saying No value given for one or more required parameters. Run time error. When I press debug: The following codes are higligted

" rs.Open pstrSQL, CurrentProject.Connection, _
adOpenKeyset, adLockOptimistic".

Here is how I used the example in my db

Names: Concatenate("SELECT ProviderID FROM Projectteammeeting2_qry1 WHERE InvoiceID = " & [InvoiceID])

Thanks

 

[Mr2006]

Alright, the above problem is solved. Thank you soo much. But one problem: it Concatenateed but instead of the names, it concatenated the IDs since the field is combobox .

Thanks

 

[dhookom]

You should have the Provider Name rather than ID in the expression. This requires the name field to be included in the query [Projectteammeeting2_qry1].

Duane
Hook'D on Access
MS Access MVP

 

[Mr2006]

dhookom,

Thank you soooooooooooooooooooooooooooo much. it worked perfectly.

thanks