B
Bill Foley
Have sort of a strange request (I guess) and was wondering if it was
possible. Access 2003.
I have three tables imported from an Excel spreadsheet that have data
selected by three different people. What I am trying to do is create a
query that only includes those records that have been selected twice. I
have created a Union Query that shows who selected what, but what I am
trying to prevent is having to scroll down and manually determine which ones
were selected at least twice.
A little background:
1. List of tasks
2. List of Systems
3. Assign/Tie tasks to systems
4. If 2 of 3 folks tied Task 001 [Task#] to System 02 [Sys#], select it.
5. Continue through all 1500 tasks
Is this possible?
possible. Access 2003.
I have three tables imported from an Excel spreadsheet that have data
selected by three different people. What I am trying to do is create a
query that only includes those records that have been selected twice. I
have created a Union Query that shows who selected what, but what I am
trying to prevent is having to scroll down and manually determine which ones
were selected at least twice.
A little background:
1. List of tasks
2. List of Systems
3. Assign/Tie tasks to systems
4. If 2 of 3 folks tied Task 001 [Task#] to System 02 [Sys#], select it.
5. Continue through all 1500 tasks
Is this possible?