[FONT="]
Hello All. I am new to using access 2002 so just bear with me.
I have 4 Input fields ( gotten from linked excel tables through a web query) as shown below:[/FONT]
[FONT="]Req #, Type, Request Item and Status[/FONT]
I already have a query that finds the “Add” Type with “Completed” Status without matching “Delete” Type with “Completed” Status. I used the wizard and it gave me the correct result. However how can I write the query that:
1. shows the very last completed Add that matches a completed Delete?
2. shows the remaining number of “Complete” “Add”s of the particular Request Item “Shared Drive” that doesn’t match “Complete” “Delete”s of the same particular Request Item?
Thank you.
Hello All. I am new to using access 2002 so just bear with me.
I have 4 Input fields ( gotten from linked excel tables through a web query) as shown below:[/FONT]
[FONT="]Req #, Type, Request Item and Status[/FONT]
I already have a query that finds the “Add” Type with “Completed” Status without matching “Delete” Type with “Completed” Status. I used the wizard and it gave me the correct result. However how can I write the query that:
1. shows the very last completed Add that matches a completed Delete?
2. shows the remaining number of “Complete” “Add”s of the particular Request Item “Shared Drive” that doesn’t match “Complete” “Delete”s of the same particular Request Item?
Thank you.