I have two tables. One with Customers down the side, and billcodes across the top. The table is populated by billcode quantities.
The second has table has two columns: Billcode and Rate. The table maps billcodes to their rates.
I want to construct a query that will multiply each billcode quantity by its rate to get revenue. How might this be constructed in Access?
Visually, here are the two tables:
Table 1:
| BC1 | BC2 |
CustA | 5 | 10 |
CustB | 3 | 8 |
Table 2:
Billcode | Rate |
BC1 | $1 |
BC2 | $2 |
Desired result:
| BC1 | BC2 |
CustA | 5 * $1 | 10 * $2 |
CustB | 3 * $1 | 8 * $2 |
The second has table has two columns: Billcode and Rate. The table maps billcodes to their rates.
I want to construct a query that will multiply each billcode quantity by its rate to get revenue. How might this be constructed in Access?
Visually, here are the two tables:
Table 1:
| BC1 | BC2 |
CustA | 5 | 10 |
CustB | 3 | 8 |
Table 2:
Billcode | Rate |
BC1 | $1 |
BC2 | $2 |
Desired result:
| BC1 | BC2 |
CustA | 5 * $1 | 10 * $2 |
CustB | 3 * $1 | 8 * $2 |