Hi,

I have two tables:

Travellers_Report

Please Login or Register  to view this content.
and Company_presence

Please Login or Register  to view this content.
I need to compare the 'Travellers_Report' table's 'Place_of_visit' field to 'Company_presence' table's 'City field' and get the count.

Expected output is:
Please Login or Register  to view this content.
Please Login or Register  to view this content.
This query gets me the result for 'Travellers_report.Place_of_Visit = company_Presence.Facility'
How to change this query to get records that are not matching? 'Travellers_report.Place_of_Visit <> company_Presence.Facility' is not showing the correct result.

In short:
1.Need to show the count of travellers reg to location where the company presence is there. in one listbox (is working with the above query)
2.Need to show the count of travellers reg to location where the company presence is NOT there (<> not working)

Pls suggest some solutions....