Hello,
I am making a database for maintaining an inventory of our hazardous waste bottles. The "containers" table has 10 text fields for the user to enter each ingredient, let's call these fields [Name1], [Name2], etc, in the bottle into, and a corresponding field to enter the concentration, lets call those [Conc1], [Conc2], etc. This concentration is a percentage, but they do not enter the % symbol. Some bottles will have all 10 of these filled out, some will only have 1. It depends on what is in the container.
I have a report that shows the "inventory" of everything in a room - each bottle, including the contents of the bottles.
On that report, I'm trying to list the contents in the following format:
[Name1] [Conc1]%, [Name2] [Conc2]%, [Name3] [Conc3]%, . . . [Name10] [Conc10] %
A simple concatenation, if there are only 2 ingredients, will show:
Ethanol 20%, Water 80%, %, %, %, %, %, %, %, %
For now, that is what I'm doing, but obviously what I want it to do is say:
Ethanol 20%, Water 80%
Could someone please help me with this? I've been trying to figure it out for several days now, I'm just lost.