Query - At my wits end!

[Dave]

I'll try to explain as best I can.

I'm trying to run a query based on 4 tables. 1 table (table1) has a
primary key to 2 separate tables each with a matching FK. One of those
tables (table2) has a FK and 2 entries(1 & 2). The other table
(table3) has FK and 1 entry with PK related to table4 with 2 entries(A
& B).

I'm creating a query for a report. Iget the data OK but I get four
results. Each of table2's results with each of table4's results. ie.
A1, A2, B1, B2.

What I want is simply two rows for the report A, B, 1, 2

I've tried every combination of sub-queries, different types of joins,
grouping in the report, etc. all to no avail. What am I missing?

Thanks all,

Dave B

PS the table names have been changed for simplification.

 

[Guest]

Please provide sample data and table structures and links plus maybe some of
the SQL that gets 'close' to your needs. That could help us visualize the
problem more clearly.

I'm always at 'whits' end.