how to handle empty fields in queries

  • Thread starter Christopher Glaeser
  • 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
 
C

Christopher Glaeser

Use an outer join between the WordOrders table and the Employees table.

Thanks! It worked!

Best,
Christopher
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

show records when two fields not equal 3
Random Top 10 percent of groups 6
Check box creates a new record when clicked??? Huh??? 3
Advanced Sorting 5
Access, Workorder Query, want to open it only if complete date is. 1
Query Design 1
Combine data in fields within one table 4
Selecting x# of records 2

Top