Is there a way to merge queries in Access? I have data from 2 different DB's and I need merge the data and present the data on 1 form.
One query will have an excel table which is then linked to a query from the 1st DB. This data represents all loans funded by an LO.
The 2nd query will be data straight from the 2nd DB. The data will be number of calls received by an LO by state. There will only be 3 columns of data.
I would like to combine the queries so the output shows the number of fundings in each state then the number of calls in each state.
Is this possible??
One query will have an excel table which is then linked to a query from the 1st DB. This data represents all loans funded by an LO.
The 2nd query will be data straight from the 2nd DB. The data will be number of calls received by an LO by state. There will only be 3 columns of data.
I would like to combine the queries so the output shows the number of fundings in each state then the number of calls in each state.
Is this possible??