Simple query "how to" question

kabaa01

New member
Local time
Yesterday, 21:30
Joined
Apr 21, 2010
Messages
2
[FONT=&quot]
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=&quot]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.
 

Users who are viewing this thread

Back
Top Bottom