Help please...Working with variable from input-box to list-box.
I have created a variable called MoreThanHrs from a input box.
I have two listbox showing staffNames and workingHours.
What can i do to make it such that whenever the user entered a value into the input-box (for.eg. 11), it will then select out workingHours that is equal or greater than 11:00, and thus showing the staffNames who has worked this amount of hours.
In addition, how can i set the default value of the input-box? meaning everytime i clear selectd fields, the input-box value and MoreThanHrs value will set back to 0?
Re: Help please...Working with variable from input-box to list-box.
The attached is a sample file u may work on. What i am trying to do is to know the working hours of the staff, and derive who are the one working more than x hours in that selected day and which are the workers who works Y consecutive days.
The qns i posted here is trying to solve the first issue, obtaining workers who work more than x hours in the selected day. As for the second problem, i am still stuck with the counter.
My tables are very messy, as i do not have rights on db, and these are what i tried to extract and load.
Thanks, i hope u really can help me. Really need your help.