Unmatched records to be set as default value - MS access

[venkateshr]

Hi Folks,

Need your expert advice on MS access query, below the scenario for your reference.

I have 2 different Table (Table1 & Table2)

Table1:

Team	Activity	Jan-2019	Feb-2019
Group1	Type1	10	20
Group2	Type1	15	22

Table2:

Team	Activity	From	To	Percentage
All	All	Jan-2019	Feb-2019	5%
Group1	All	Jan-2019	Feb-2019	4%

Table1 is master and Table2 has matching or unmatching records to Table1
I need a query which Can identify Table2-> Having value "All" which will be unmatched records to Table1 and this unmatching records(percentage Column) to be set as default value in the query result for each month for each row.

Kinldy suggest best way to arrive the result.

Regards,
Venkatesh

 

[welshgasman]

Cross posted.
MS-Access Unmatched records to be set as default value

 

[Joe4]

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.