I have set up a simply query as shown in attached (.pdf)
[specjobs] is my main Project database, [Job Process] is where the users put their project notes. [Architect] is a database containing Architectural Firms that would be involved in the design of the Project
The way the query is set up, I would like the Architect info included in the report I generate. Unfortunately, not all projects have an Architect involved in it, so those projects will not show up on the report.
How can I get a project to show up on a report even when it does not have an Architect involved?
Thank you
[specjobs] is my main Project database, [Job Process] is where the users put their project notes. [Architect] is a database containing Architectural Firms that would be involved in the design of the Project
The way the query is set up, I would like the Architect info included in the report I generate. Unfortunately, not all projects have an Architect involved in it, so those projects will not show up on the report.
How can I get a project to show up on a report even when it does not have an Architect involved?
Thank you