C
cableguy47905 via AccessMonster.com
This has been very frustrating because I know I should be able to get this.
I am just going around in circles with it though.
I have three different tables.
The only common field is the Project field.
One table has all Pending Projects sent by my group.
One table has all Reported Projects by all groups.
One table has all Resolved Projects by all groups.
Of course all of the Resolved Projects are in the Reported table, but there
are also some resolved projects that are not in the Pending table.
Some Reported Projects are in both of the other two tables, but there are
also some that are not in either table.
Basically what I want is a query that will show all of the projects with the
correct status. If the project is in the Resolved table, then it should only
show once with the status of "Resolved". If the project is only in the
Reported table, then it should only show once with the status of "Reported".
And the same for the Pending table projects. However, there are instances
where the project is in more than one table in I want it to only show up once
with the correct status. The hierarchy is Resolved, Reported, Pending.
How can I accomplish this? I know SQL, but it has been a little while and I
am a bit rusty at it. Can anyone help me with this?
Thanks in advance,
Lee
I am just going around in circles with it though.
I have three different tables.
The only common field is the Project field.
One table has all Pending Projects sent by my group.
One table has all Reported Projects by all groups.
One table has all Resolved Projects by all groups.
Of course all of the Resolved Projects are in the Reported table, but there
are also some resolved projects that are not in the Pending table.
Some Reported Projects are in both of the other two tables, but there are
also some that are not in either table.
Basically what I want is a query that will show all of the projects with the
correct status. If the project is in the Resolved table, then it should only
show once with the status of "Resolved". If the project is only in the
Reported table, then it should only show once with the status of "Reported".
And the same for the Pending table projects. However, there are instances
where the project is in more than one table in I want it to only show up once
with the correct status. The hierarchy is Resolved, Reported, Pending.
How can I accomplish this? I know SQL, but it has been a little while and I
am a bit rusty at it. Can anyone help me with this?
Thanks in advance,
Lee