This time I promise I'm stuck

[Sway2119]

I have 9 seperate tables - each of the tables has similar headers

Claim #
Agent
Pass/Fail
Request type
Record Date

I have built relationships between all the tables. I am attempting have a singular query be run based on start and end dates under "record date"
I have the criteria already set. But when I run the Query no information is pulled. How do I get the query to pull this data from all 9 tables?

 

[jdraw]

Show us the sql of the query.

 

[Sway2119]

Thank you everyone for the views. but i was able to figure it out. using the Union Query function.