I have two queries A_Q and B_Q. (simplified the names)
Each gives a list of projects that will be funded, based on different funding limits for each and uses a Balance field where the criteria is >0, to show only the projects that can be funded.
Both queries have a unique ProjectID, but have been queried differently based on the funding type.
I want to combine these two queries to show all the projects to be funded. i.e. all the ProjectIDs, ProjectTitles, etc.
How can I do this?
Each gives a list of projects that will be funded, based on different funding limits for each and uses a Balance field where the criteria is >0, to show only the projects that can be funded.
Both queries have a unique ProjectID, but have been queried differently based on the funding type.
I want to combine these two queries to show all the projects to be funded. i.e. all the ProjectIDs, ProjectTitles, etc.
How can I do this?