vash011390
New Member
- Joined
- May 18, 2015
- Messages
- 4
Hello All,
I am trying to create a Ms Access database that will generate an automatic variance explanation comparing two periods in two tables and the comparison in third table. This will help me eliminate the time spent on tedious (manual) comparison of various increases and decreases between lines. I don't know how to start - which query to use or maybe macro can help so I am seeking professional help.
Actually I already created .xlsm file with customized sumif but the file is soooo slow to generate variances...
A million thanks to all who will help.
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Table 3
Pivot of the two tables and increase decrease.
<tbody>
</tbody>
<tbody>
</tbody>
I am trying to create a Ms Access database that will generate an automatic variance explanation comparing two periods in two tables and the comparison in third table. This will help me eliminate the time spent on tedious (manual) comparison of various increases and decreases between lines. I don't know how to start - which query to use or maybe macro can help so I am seeking professional help.
Actually I already created .xlsm file with customized sumif but the file is soooo slow to generate variances...
A million thanks to all who will help.
Table 1
Year | Month | Chartline | Counter | CounterName | Balance |
2015 | 6 | 1000 | a1 | far | 200 |
2015 | 6 | 3000 | a1 | far | 150 |
2015 | 6 | 1000 | a1 | far | 40 |
2015 | 6 | 1000 | a2 | slow | 10 |
2015 | 6 | 2000 | a2 | slow | 30 |
2015 | 6 | 1000 | a3 | big | 500 |
2015 | 6 | 1000 | a3 | big | 100 |
2015 | 6 | 2000 | a2 | slow | 200 |
2015 | 6 | 5000 | a1 | far | 100 |
2015 | 6 | 2000 | a1 | far | 20 |
2015 | 6 | 1000 | a2 | slow | 10 |
2015 | 6 | 1000 | a1 | far | 10 |
2015 | 6 | 3000 | a3 | big | 70 |
2015 | 6 | 2000 | a1 | far | 50 |
<tbody>
</tbody>
Table 2
Year | Month | Chartline | Counter | CounterName | Balance |
2015 | 3 | 5000 | a1 | far | 200 |
2015 | 3 | 2000 | a1 | far | 100 |
2015 | 3 | 1000 | a1 | far | 20 |
2015 | 3 | 1000 | a2 | slow | 10 |
2015 | 3 | 3000 | a2 | slow | 10 |
2015 | 3 | 2000 | a3 | big | 70 |
2015 | 3 | 1000 | a3 | big | 50 |
2015 | 3 | 3000 | a2 | slow | 200 |
2015 | 3 | 1000 | a1 | far | 150 |
2015 | 3 | 1000 | a1 | far | 40 |
2015 | 3 | 2000 | a2 | slow | 10 |
2015 | 3 | 1000 | a1 | far | 30 |
2015 | 3 | 1000 | a3 | big | 500 |
2015 | 3 | 2000 | a1 | far | 100 |
<tbody>
</tbody>
Table 3
Pivot of the two tables and increase decrease.
Chartline | 1000 | |||
Sum of Balance | Month | |||
Counter | CounterName | 3 | 6 | Inc(Dec) |
a1 | far | 240 | 250 | 10 |
a2 | slow | 10 | 20 | 10 |
a3 | big | 550 | 600 | 50 |
Grand Total | 800 | 870 | ||
<tbody>
</tbody>
Explanation: |
INCREASE $10 FAR, $10 SLOW, $50 BIG. |
<tbody>
</tbody>