Forum Discussion
Solved
Pulling selected rows from a table based on multiple criteria
I deal with projects, that have many tasks. I maintain them in a table where there is a row for each task, and from the many columns for each task, the Status column is used to monitor progress (has ...
Maprach You should be able to use a Merge tables query to merge that column in the table with the Tasks table to get all of the tasks for those projects.
Maprach You should be able to use a Merge tables query to merge that column in the table with the Tasks table to get all of the tasks for those projects.
Greg_Deckler Yes, you are right, Merging does it. Thank you very much! I also found that if I connect these two tables, in the matrix visual I can list Projects from the Active Projects table and then add tasks from the big table, with their statuses, it also does the trick. Not sure why I did not see that before. But you have helped greatly. Thank you.