I work as an assayer at a small laboratory. We analyze different elements in mineral samples. For example, on Sample 1 we will determine lead and zinc concentrations, while on Sample 2 we will determine lead and iron concentrations.
On Access, I have a table that has a field for the sample ID (short text), and a field for de n number of assays on that sample (multiple combo box).
I was wondering if there is a way to create a table/report from this first table (mentioned above), where the rows contain the sample information and the number of columns will change and depend of the different assays on those samples. Continuing with the example, the table would have two rows, as for Sample 1 and Sample 2, and three columns, for the elements of lead, zinc and iron. If this number of elements would ever change, so would the number of columns.
I been struggling with this for quite a while now, if someone could help me, I will much appreciate it.