We are attempting to creat a report which will display information stored in several (4) different tables. The database tracks construction projects, both planned and currently underway. Each job is identified with a unique code and that code is part of each of the tables.
Basically what we need is a report to show various fields from each table on the one report. Should be simple enough. But we can't get it to work properly. Here's what we did.
We created a query which pulled data from each of the necessary tables and used the Job Code as the relation. It kind of works. but the problem is that if one of the fields in one of the tables is blank, the query won't pull any info for that job from any other table, thus eliminating that job entirely from the report. For example, the anticipated completion date is in one table and is one of the fields we want to display on the report. But if it's empty, which is often the case, the query won't display any of the other data for that job from any other table. It is possible for a planned construction project to have a project code, name, budget, etc. without a completion date.
So what we need is for all records to show up on the report regardless if one of the fields is empty.
Hope this makes sense, and hopefully someone can help out with an easy answer.