When creating a query that requires data pulled from more than two linked tables, I get all kinds of funny problems. If any of the records in the linked tables have blank fields that I want displyed in the output, the record simply isn’t included. I’d like the record from the primary table included even if the data from the linked tables is missing. Some is better than none. The problem is only records with all the fields filled in all the linked tables appear! I assume this is a limitation of the query tool when it converts it into SQL. I know just enough SQL to get by and add a little extra here and there. I probably need to start getting into SQL scripting a bit deeper, as what they want is outrunning what I’m able to provide. I’ve temporarily overcome this problem by filling otherwise null fields with “N/A” and providing dummy linked records that would otherwise not need to be there. This way, all records in all linked tables have a linked record in the others and all fields are filled. Now, instead of being blank, null fields say “N/A”. It’s cumbersome and creates a lot of waste data, but it fixed the problem. Now, will someone please tell me how to do it right? If someone should happen to go into the tables and accidentallydelete one of the dummy records because it doesn’t look right, it will screw everything up! I should add that I’m a PC tech/Network administrator, not an Access developer. I don’t have any formal training or resources outside of the help files, so an obvious problem to others may escape me. You have to be sharp at a bit of everything these days it seems.