how to handle empty fields in queries

  • Thread starter Thread starter Christopher Glaeser
  • Start date Start date
C

Christopher Glaeser

tblWorkOrders has a field AssignedTo that is a link to tblEmployees.
Suppose that some WorkOrders have been assigned an employee, while others
have not yet been assigned. How do I create a Query that lists all the
WorkOrders including the names of assigned employees, and if not yet
assigned, then a blank field for the name? When I try to create a Query, it
skips all the WorkOrders that have not yet been assigned to an employee. I
don't want to skip any workorders, but rather have a blank in the "assigned
to" field if not yet assigned.

Best,
Christopher
 
Use an outer join between the WordOrders table and the Employees table.

Thanks! It worked!

Best,
Christopher
 
Back
Top