I created two queries in MS Access - we'll call it Custom 1 & Custom 2 for brevity sake. I need to know how to create the fields in both of these queries and combine it to one single query instead of having two different ones. So the new query will be Custom 3.
Secondly, the last information is the type of organ transplant which I want to include in Custom 3. But that information is stored in yet another database, different from the original one which I ran for Custom 1 & 2. How do I do that?
We'll need to know what exactly the queries are that you are trying to combine, along with the database layout and relationships. As for your 3rd query in a seperate database, you might be able to link the 2 databases together by going to File > Get External Data > Link Tables.