Access Report, How do you make the report query grab 2 databases and make it into one

[anoble1]

I am trying to make a report that compares one database to another. Maybe I can make some sense out of this. I am trying to make a query, that actually opens the other database in the background (hidden) and brings the query over to the Main database where my report will reside that will compare the 2 numbers. Then finally put the 2 querys together to make 1 report. Can this be done?

[anoble1]

Actually, I found a way to do kind of what I was thinking. I opened up a query and went to properties. Then Set the Source Data to the link of the other database. Well, how do I get 2 databases set to the source?