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

1/1/2018	,ABC	123
1/2/2018,	ABC	12301
1/1/2018,	BCD	145
1/2/2018,	BCD	14502

<colgroup><col width="64" style="width: 48pt;" span="3"> <tbody> </tbody>

youd have better results with Excel

<colgroup><col width="64" style="width: 48pt;" span="2"> <tbody> </tbody>