Hello.
I trying to build my own database in Microsoft Access 2013. I have the following tables:
Passanten (Table with objects, a passant is a type of healthcare)
Zorgaanbieders (Table with different healthcompanies)
Pas_zorg (Table with passantenID, ZorgaanbiederID, price2016 and price2017)
Im filling the Pas_zorg table with passant prices from different companies. Now I want to compare the prices from company A to B etc. to see what company gives the cheapest "passanten".
The problem: The table passanten has around 7000 unique records and companies dont give information about all the passanten. Example: Company A has 5000 passant prices and company B has 3000 passant prices.
If I Compare both companies in total the result wont be correct because some companies have more prices and the total score will be bigger than company B. Is there a possibility to compare only records if they are both filled?
Hopefully you will understand my description!
Kind regards,
Jelto Christiaens
The Netherlands