Microsoft Access: How to Compare two Fields in two different tables. #microsoft #access

Описание

Hello my Friends,
In this video I will show you how you can compare two Fields, in two Different tables that contain the exact same data, and getting the result "same" if the data is matching and different if the data is different.
Step 1: Creating a relation between the two tables.
Step 2: Creating a report that contain all the fields we want.
Step 3: Creating a control (text box) to put the result (same, difference) inside it.
Step 4: Writing an IF Formula to get the result.
step 5: check our report and correct the wrong data in the main table.
---------------------------------------------------------------------------------------------------------------------------
Music:
Music by Wavecont, https://www.wavecont.com/free-download/
Licensed under creative commons Attribution-ShareAlike 4.0 International
https://creativecommons.org/licenses/by-sa/4.0/
Music promoted by https://www.chosic.com/free-music/all/
---------------------------------------------------------------------------------------------------------------------------
How to compare two table in MS Access?
https://youtu.be/jZU02OIT4H4
---------------------------------------------------------------------------------------------------------------------------
Thanks for your support,
Don't forget to like this video and share it.
And subscribe to our YouTube channel.