Concatenating Values to a Single Textbox

[Ramtrap]

Hi All,

I've gotten a lot of help through here in regards to putting a bunch of values into a single textbox via this link: http://allenbrowne.com/func-concat.html

Now I've come across another issue. Some background:

I have a Conference Scheduling Database that is structured, for the most part, as below:



These are the results of the query:


This is the form results:


These are how I want my results to look:


The issue I want to solve is I want to allow a user to view all the days of a conference someone may attend. The way it works is like this:
Someone creates two conference: Conference X and Conference Y
Conference X is a three-day conference (Day 1, Day 2, Day 3)
Conference Y is a one-day conference (Day 1)


Because conferences can be single or multi-day, I have the two tables. The "Conference_Main" table allows for the creation of the actual conference...the marquis, if you will. It will then automatically create Day 1, as all conference HAVE to have at least one day.

Now, the Person_to_Conference table is a table that tracks what people are going to what conference, and what days (tracking by their individual IDs). I'm not sure if it's a query issue or a "WHERE" issue that I need solved to return the appropriate data. Right now, my function, created from the link above, goes like this:
=ConcatRelated("Day","Qry_PerToConfByDay","PersonID=" & [PersonID] And "ConferenceID=" & [ConferenceID])

I get results that show the collection of all persons and all the days that have been attended. Can someone please help me with my query, or is my WHERE statement (in red) wrong?
Thanks!

[ranman256]

have you tried a Crosstab query to do this?

[Ramtrap]

have you tried a Crosstab query to do this?

I haven't. Still an Access newbie, but I'll do some research and see what I can come up with. Thanks for the suggestion!

[CJ_London]

try

"PersonID=" & [PersonID] & " And ConferenceID=" & [ConferenceID]

[Ramtrap]

try

"PersonID=" & [PersonID] & " And ConferenceID=" & [ConferenceID]

<Slow clap> That works perfectly. Im in your debt. I promise to notify any future cross-post, and apologize for it. Thank you very much!