Using concatenate function but only want to concat some of the results

[bigalpha]

I'm building an inventory to keep track of jewelry.

1 ring can have multiple gems and be made of multiple metals. However, this ring can also have no gems.

The ring will cost different prices depending on the mixture of metals and gems (or no gems).

I'm creating a report [rptLineSheet] (with subreports) to show Ring 1 in the following fashion:

Ring 1
Diamonds + Emeralds
Gold: $1000
Silver: $800

No Gems
Gold: $900
Silver: $700​

I can easily concat the names of the gems. However, the query also lumps in "No Gems" so I only end up with:

Ring 1
Diamonds + Emeralds
Gold: $1000
Silver: $800​

In order for my set-up to show that second block (The "No Gems" section) is if I end up with two records (instead of one) in my query, which I cannot seem to figure out. I am concatenating in the source query for the above mentioned report and concatenating from qrt GemTotalsReport1.

Any help is greatly appreciated. I've attached my db, which I'm still building.