How to return a count of related Records and concatenate those records in a field

[gmaxey]

Thank you. I will look and attempt to understand/employ in the larger project.

BREAK

Very interesting.

The Select Count (which I was not aware of) eliminated some complications. Question: What is the meaning/purpose of ("1") in the e.g, Count ("1"). I can change that to 2, 3, 100 or Man in the moon for that matter and I get the same results.

The ultimate goal at the end of the day is to present this query information in a from and or report. Do you know how to convert Issues e.g., "Test Issue 1/Project 1, Test Issue 2/Project 1" ...

... into a multiline display in the report or form. Or display as multiple lines back in the query?
Test Issue 1/Project 1
Test Issue 2/Project 1