query not returning any records

[Slez via AccessMonster.com]

I am ultimately looking to generate a report that repeats itself for each
client listed in a table. (Similar to how a mail merge would work.) For
instance, we create a proposal for a given project, and in a related table
called tblProjectClient, we may have only one client or many clients. This
table is on the many end of a one-to-many relationship with tblProject.

tblProject is also on the one side of one-to-many relationships with a series
of other tables.

I created a query which pulls all the related records and it works properly
until I add fields from tblProjectClient. Then the query doesn't return any
records.

Does this require a different type of JOIN or is this a scenario where I make
2 separate queries, and address this in the report?

Any suggestions are appreciated!
Thanks
Slez

 

[Jerry Whittle]

Please show us the SQL. Open the query in design view. Next go to View, SQL
View and copy and past it here. Information on primary keys and relationships
would be a nice touch too.

 

[Slez via AccessMonster.com]

I went into my query and now am getting some results, so I am going to hold
on posting anything else until after the holiday. Thanks for replying! I
still will likely need some assistance on this, but will take some steps to
narrow down what my issue is.
Slez

Please show us the SQL. Open the query in design view. Next go to View, SQL
View and copy and past it here. Information on primary keys and relationships
would be a nice touch too.

I am ultimately looking to generate a report that repeats itself for each
client listed in a table. (Similar to how a mail merge would work.) For

[quoted text clipped - 15 lines]

Thanks
Slez