Calculating results by combining two tables in MSaccess

[khandelwal]

I want to draw a result based on data available in two different tables in the same database. Basically, I want to calculate the % share from both of these tables
My Table 1 looks like this and has data somewhat like this.
| Code | Category | |------|----------| | ABC | 123 | | BCD | 145 | | DEF | 0 | | ACF | 5 | | BCF | 1588 |
My Table 2 looks like this and has data somewhat like this.
| Code | Category | |------|----------| | ABC | 12301 | | BCD | 14502 | | DEF | 3255 | | ACF | 7049 | | BCF | 15234 |
I want to divide Table A result matching to Table 2 results in a single query. My outcome should look like this
| Code | % | |------|--------| | ABC | 1.00% | | BCD | 1.00% | | DEF | 0.00% | | ACF | 0.07% | | BCF | 10.42% |
Need help with a way to calculate the same in MSAccess.

 

[ranman256]

your table is not designed correctly for a database.
for a db, there would only be 3 columns:
date, code, cata
[TABLE="width: 144"]
<colgroup><col width="64" style="width: 48pt;" span="3"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: right"]1/1/2018[/TD]
[TD="width: 64, bgcolor: transparent"],ABC
[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]123[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/2/2018,
[/TD]
[TD="bgcolor: transparent"]ABC [/TD]
[TD="bgcolor: transparent, align: right"]12301[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/1/2018,
[/TD]
[TD="bgcolor: transparent"]BCD[/TD]
[TD="bgcolor: transparent, align: right"]145[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1/2/2018,
[/TD]
[TD="bgcolor: transparent"]BCD[/TD]
[TD="bgcolor: transparent, align: right"]14502[/TD]
[/TR]
</tbody>[/TABLE]

youd have better results with Excel

[TABLE="width: 96"]
<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent, align: right"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]
[/TD]
[TD="bgcolor: transparent, align: right"][/TD]
[/TR]
</tbody>[/TABLE]