I don't get what I am missing. On the images it can be seen that I linked three queries, which have the id field in common. Query q04SalesPrice03 has 8 records and it shows fine in the linked query. I need the same from the other query q04CogsUnitPrice02. Query q01CombinedEntity keeps all entities. q04CogsUnitPrice02 returns #Error for the records in q01CombinedEntity that has no record in q04CogsUnitPrice02. If I use Nz(Dlookup("ActualSalesPrice011","q04CogsUnitPrice 02","IntItmID011 ="& CmbEntID001),0) the same happens. I adde a 4th query which returns the same. If there is a record the amount is correct, if no record then #error. I wonder why one query links fine the other two not?