I have a tblProject that contains projects and their phase of execution.
Each project can be in one of the following three phases:
Portfolio, Pre-project or Execution
I want to show a table in a form containing the names of projects in each
I thought of using a query where the columns are the project phases and the
query would return the names of the projects in each of these phases.
Let say the query result would be:
PORTFOLIO PRE-PROJECT EXECUTION
Projetct1 Projetct4 Projetct5
Project2 Project7 Projetct6
But I couldn do this. I don know if it possible because I don know if
a query can apply criteria to show in different columns (Portfolio, Pre-
Project and Execution) values from the same table column (column Phase from
Can anyone help me?
Thank you very much,
Message posted via AccessMonster.com