Is it possible to pair two independent table colums or somehow group them in Access?
I'm assembling a table grouped by entites (divisions) to show projected budget cuts. As you can see by the illustration, I've got A column for each division, and colums for amounts given a projected 1,2,3,4 percent budget cut.
I need the percentage reduction colums grouped with options for where each division will cut its budget. Each division will have a short list of options (A=reduce hours, B=reduce pay, C=reduce travel budget, or D=reduce overtime)... These are the only available options for any percent.
I need the amounts in the percentages paired with the options so I can get a total amount of money saved by each option. So when I query option A, it will return all the dollar amount fields tied to the option fields.
I'm assembling a table grouped by entites (divisions) to show projected budget cuts. As you can see by the illustration, I've got A column for each division, and colums for amounts given a projected 1,2,3,4 percent budget cut.
I need the percentage reduction colums grouped with options for where each division will cut its budget. Each division will have a short list of options (A=reduce hours, B=reduce pay, C=reduce travel budget, or D=reduce overtime)... These are the only available options for any percent.
I need the amounts in the percentages paired with the options so I can get a total amount of money saved by each option. So when I query option A, it will return all the dollar amount fields tied to the option fields.
