sudarshank2
New Member
- Joined
- Nov 1, 2015
- Messages
- 12
Hi,
I have a table in Access which contains sales total. I need only Top 2 Values in each column.
My input data is below:
<colgroup><col span="8"></colgroup><tbody>
</tbody>
My output data should be: (Top 2 Values in Each Column)
<colgroup><col span="8"></colgroup><tbody>
</tbody>
SQL Query or VBA both are fine for me.
Can somebody please help.
I have a table in Access which contains sales total. I need only Top 2 Values in each column.
My input data is below:
Prd_Code | Prd_Desc | Cat_Code | Cat_Desc | Q1_Sales | Q2_Sales | Q3_Sales | Q4_Sales |
111 | ABC | 11 | A | 12 | 12 | 87 | 34 |
222 | DEF | 22 | B | 43 | 56 | 56 | 56 |
333 | GHI | 33 | C | 45 | 34 | 67 | 75 |
444 | JKL | 44 | D | 56 | 67 | 54 | 78 |
<colgroup><col span="8"></colgroup><tbody>
</tbody>
My output data should be: (Top 2 Values in Each Column)
Prd_Code | Prd_Desc | Cat_Code | Cat_Desc | Q1_Sales | Q2_Sales | Q3_Sales | Q4_Sales |
111 | ABC | 11 | A | 87 | |||
222 | DEF | 22 | B | 56 | |||
333 | GHI | 33 | C | 45 | 67 | 75 | |
444 | JKL | 44 | D | 56 | 67 | 78 |
<colgroup><col span="8"></colgroup><tbody>
</tbody>
SQL Query or VBA both are fine for me.
Can somebody please help.