I have a query where I want to pull out the Name, Company, Last Contact Date and Type of Programming from several different tables in the database.

Name and company are in the same table and are both the Name field. Contact_Number of 0 is a company, any other Contact_Number is a person.

The user must have a Last Contact Date in order to be included in the query, so I have 3 joins to get the required information from the 3 tables.

Now where I am getting stuck is that I need to do another join to get the Type of Programming field.

The table that holds the Type of Programming field shares a ClientID with my main table, so the relationship is there, when the Type of Programming value has been entered.

My problem lies with the fact that whether or not the user has a Type of Programming field, I still want them in my query.

I'm going to re-read this and possibly add more information in case it doesn't make any sense.

The condensed version: I need the Type of Programming field to display whether there is an entry for it or not. The only way I know to display a field is through a join, but you can't join on nothing as far as I am aware.