Query Result Help

[chaddresnick]

I am trying to assign each person in my office an "office number". My problem is that the ID comes up in my query instead of the "office number". I have attached screen shots of my table, query design and query results. Any help that you can provide will be greatly appreciated.

[June7]

Include Offices table in the query so the related descriptive info is available.