Search results

Hi, I have a problem with the Nz (nulltozero) function in a query. The Nz function works well as long as there is a record , even if the field is empty, so far so good, but when there is no entry at all at one of the tables, the the Nz does not function. Example Table1 > field A contains...