Hello! I am writing a query based on 3 tables. The first 2 tables provide all the information I need, except 1 field (FullName). That field is an another table. It is a Concatenated field (FullName). Running the query with the 2 tables works well but, obviously, no FullName field. If I add the 3rd table with no links, I get many identical answers If I try to link the tables, using what appears to be sensible, same name, fields - I get no answers.
Table 1 has two fields, IDField plus one field.
Table 2 has a number of fields including the IDField of the first table and the IDField of the 3rd table.
Table 3 (Master1) has many fields including the IDFields of the first 2 tables and the required answer in the query "FullName"
Tables 1 and 2 are joined by the IDField of Table 1.
I thought I was quite good at queries but this concatenated field is proving to be difficult. Leon