Duplicates in Query result (1 Viewer)

Status
Not open for further replies.

June7

AWF VIP
Joined
Mar 9, 2014
Messages
2,691
There's the conundrum. Had to remove Index values to eliminate duplicate Action descriptions because some descriptions had 2 Index values associated so Index is not available for sorting. Where did these Index values come from? Why not have same Index for description regardless of which table it is in? Which of the 2 Index should be used? Then sounds like different sort criteria for first 2 weeks.
 

Lkwdmntr

Registered User
Joined
Jul 10, 2019
Messages
188
So if you noticed there are no duplicates and I am using the index in the query. I figured out a way around the index problem. I put a WHERE statement in Query1 that filters out all the actions with an index > 200, which are all the duplicates. Should have done that in the beginning. Live and learn.
 

Lkwdmntr

Registered User
Joined
Jul 10, 2019
Messages
188
Hello, I have been busy putting a form into the project. I still need help getting the sorting down. The first two weeks should be sorted by the index(which you can use) and then from week 3 and on, any action added should show up on the bottom of the list. If an action is swapped and added back later in the program, the action should remain where it was when it was first chosen. All the X's should increase down and to the right just like the excel file that was sent earlier.

When you open the new database, Hit "Enter", "History/Reports", select the user "Thomas Deiter" and hit "Next". The new form shows up, but not in the proper order. Please help. Here is the new link to the updated database.


Thanks again for all your help!
 
Status
Not open for further replies.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom