Hello Folks,
I have two tables inserted in a query that are linked together by last name. Table one has the last names with a designated title in a specific column labeled ID. Table two has the last names also, as well as many columns with a lot of assorted data. I need to add the title number to the records in table two in a new ID column. This is obviously easy except that not all names on table two are on table one. In this case only the names that are in table one end up in the output table of this query. I would like to add an additional tile "N/A" to the records that did not include the names on table one. Most importantly I need to make sure all record from table two are carried into the output table of this query.
I have both tables in the design view linked to gether by last name. I have all columns from table two listed in the output design. I have added the ID column from table one to pull the title forward to the corresponding records in table two. I just can not pull the null ID record forward with this query and ultimately rename the null records "N/A"
Any suggestions of how I can accomplish this in design view of the query. I am not very Access savy (as you can tell). Detailed instructions would GREATLY be appreciated.
Thank you in advance for the assistance.
JB
I have two tables inserted in a query that are linked together by last name. Table one has the last names with a designated title in a specific column labeled ID. Table two has the last names also, as well as many columns with a lot of assorted data. I need to add the title number to the records in table two in a new ID column. This is obviously easy except that not all names on table two are on table one. In this case only the names that are in table one end up in the output table of this query. I would like to add an additional tile "N/A" to the records that did not include the names on table one. Most importantly I need to make sure all record from table two are carried into the output table of this query.
I have both tables in the design view linked to gether by last name. I have all columns from table two listed in the output design. I have added the ID column from table one to pull the title forward to the corresponding records in table two. I just can not pull the null ID record forward with this query and ultimately rename the null records "N/A"
Any suggestions of how I can accomplish this in design view of the query. I am not very Access savy (as you can tell). Detailed instructions would GREATLY be appreciated.
Thank you in advance for the assistance.
JB
