robwilsonirl
New member
- Local time
- Today, 21:56
- Joined
- Jan 4, 2013
- Messages
- 6
Hi
I've an access query which i am trying to write but getting very confused and am considering writing it as a VBA macro.
If anyone could help with the SQL query, i'd be very grateful.
My issue is as follows.
I have users who run processes for a given account. Each process contains a task. One particular task is called the "Sweep" task. This task can also be a process of the same name.
e.g.
So, you can see above that the user ran the Trade Capture process and they ran the Sweep process. So, there is unnecessary of the sweep process twice.
I want to figure out how to list all the accounts which ran a Non-sweep process and also ran a sweep process. In the above data, i would like to see all the first 3 rows. I would not want to see row 4 or 5, as there is no duplication of the sweep task.
Any help appreciated : )
Rob
I've an access query which i am trying to write but getting very confused and am considering writing it as a VBA macro.
If anyone could help with the SQL query, i'd be very grateful.
My issue is as follows.
I have users who run processes for a given account. Each process contains a task. One particular task is called the "Sweep" task. This task can also be a process of the same name.
e.g.
PHP:
Process Task Account
Trade Capture Sweep 123
Extrap Sweep 123
Sweep Sweep 123
Sweep Sweep 456
Trade Capture Sweep 789
So, you can see above that the user ran the Trade Capture process and they ran the Sweep process. So, there is unnecessary of the sweep process twice.
I want to figure out how to list all the accounts which ran a Non-sweep process and also ran a sweep process. In the above data, i would like to see all the first 3 rows. I would not want to see row 4 or 5, as there is no duplication of the sweep task.
Any help appreciated : )
Rob