I have a query with two tables, both tables have one field that has the same field name which is "TYPE". One table has "Full-time" and the other table has "Part-time". Both tables also have a field "Name Employee".
How do I define this in the query so that it looks at "Name Employee" and then based on the employee will show one column with either Full-time or Part-time.
Currently I have three columns, Name Employee, TYPE-Full-time & TYPE-Part-time.
I want only two columns, Name Employee & TYPE and in the single TYPE column it will either have Full-time or Part-time