I have a query that has multiple tables linked together.
I have 1 table which is causing abnormal behavior. If I link to this table, Left join to the main data table and only want records from this table that match the main table, it only returns the values if the of both tables if they match.
If I delete this table from the query it works as it should. I'm not sure if I have some setting wrong, or what.
Any thoughts on what I could check would be greatly appreciated. The joins are correct.