I have a subform that contains two column describing a pesticide. The first column is a lookup (compound), the second is a decimal (concentration).
However, in one of my reports, I have to summarize all this information in one line.
For example:
Product A (Single_line)
Subform:
Compound 1 Concentration 1
Compound 2 Concentration 2
To be displayed like that in a Single_line:
Product A - Substance 1 (Concentration 1) + Substance 2 (Concentration 2)
Is it possible?