Stacy Rueda
Board Regular
- Joined
- Jun 23, 2016
- Messages
- 87
Hi
Good Day.
Can someone please help me regarding table in Access. I have data from excel which I imported to Access. Can you have an easy way to compare two data which is duplicate names but different quantity.
Example below.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I am checking this manually by moving my eyes up and down.lols. Guys can you help me on how to import to Access that automatically fit on the quantity from Excel 1 and 2. Thank you so much
Good Day.
Can someone please help me regarding table in Access. I have data from excel which I imported to Access. Can you have an easy way to compare two data which is duplicate names but different quantity.
Example below.
EXCE1 | EXCEL2 | EXCEL1.QTY | EXCEL2.QTY |
APPLE | APPLE | 8 | 10 |
APPLE | APPLE | 10 | 8 |
BANANA | BANANA | 6 | 3 |
BANANA | BANANA | 3 | 6 |
CHERRY | CHERRY | 2 | 3 |
CHERRY | CHERRY | 3 | 2 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I am checking this manually by moving my eyes up and down.lols. Guys can you help me on how to import to Access that automatically fit on the quantity from Excel 1 and 2. Thank you so much