Hi there! I want to filter out my database via three different conditions,
- Leave type should only include the phrase ‘Rest Day’.
- By individual Employee ID
- By the weeknum* (with the weeknum starting from Monday)
After which, I would like to count the number of remaining data rows are left. If there are more than one, I want to note the instances in a string.
Eg. 13/12/2021, 14/12/2021, 19/12/2021
I can complete the first two filter conditions, however when it comes to filtering the weeknum and adding the instances to a string, there may be duplicates as there are more than 1 record per weeknum.
I would like to use the remove datarow to avoid the duplicates, however I would not be able to do this in a loop. I’m not sure if there are any alternatives to this…
I am not familiar with code and such, however I would not turn away any suggestions that may help… hopefully someone will see this and help advice
As a new user, I can’t seem to attach a sample. Hopefully the explanation above is clear.