Poundland
10-29-2015, 09:43 AM
Hi Guys,
Once again I call on your collective wisdom to assist me on a coding issue,
I will not go into the full details, but I am trying to construct a code line, current code is below;
If Whoff > allo And Whoff >= rsstoreconday And rsconf_time <= "16:00" Then
I have another variable to add into the mix, Cycday.
My dilemma is this;
Whoff will always be a value between 1 and 7, allo will always be a value between 1 and 7, rsstoreconday will always be a value between 1 and 7 and rsconf_time will be a time value between 06:00 to 22:00, the variable I want to add will always be a value between 1 and 17.
I want to construct the code line as above but by adding in the variable Cycday, but to make the argument True if Cycday is greater than 7.
If the code line returns a False argument then the routine adds 1 to the Cycday variable.
I will attach the documents for you to check through, all the code lines work with the exception of the above which always returns a false argument which should otherwise be true if the Cycday variable was considered.
I hope I have made sense...
Thanking you in advance for your help.
P.S. The Master Copy would be a much larger document with over 600 records but to simplify I have reduced to 2 records.
Once again I call on your collective wisdom to assist me on a coding issue,
I will not go into the full details, but I am trying to construct a code line, current code is below;
If Whoff > allo And Whoff >= rsstoreconday And rsconf_time <= "16:00" Then
I have another variable to add into the mix, Cycday.
My dilemma is this;
Whoff will always be a value between 1 and 7, allo will always be a value between 1 and 7, rsstoreconday will always be a value between 1 and 7 and rsconf_time will be a time value between 06:00 to 22:00, the variable I want to add will always be a value between 1 and 17.
I want to construct the code line as above but by adding in the variable Cycday, but to make the argument True if Cycday is greater than 7.
If the code line returns a False argument then the routine adds 1 to the Cycday variable.
I will attach the documents for you to check through, all the code lines work with the exception of the above which always returns a false argument which should otherwise be true if the Cycday variable was considered.
I hope I have made sense...
Thanking you in advance for your help.
P.S. The Master Copy would be a much larger document with over 600 records but to simplify I have reduced to 2 records.