I have two different levels of people who want to see my production
report.
We get orders which each call for one of five products.
One level wants to see a spreadsheet type report with six columns, one
for the order number and a column for each product. This report would
show the quantity ordered in the column for that product.
The other level wants to see a three column report. The report would
show the order number, a column with the product name, and the last
column would show the quantity.
I know how to make the report for the first type but I don't know how
to do the same without making another table like the report.
Specifically, I don't know how to get the name of the one of the five
columns that has the quantity in it. The name of that column would
then be the entry in the second column.
Please tell me if I can do this.