Hi All,
Let's see if I can explain what I want.
I am putting to together a Printing Requistion System (Fancy Title) whereby Staff fill in a Grid and Upload the file to the Print Room Operator.
All is going well and is nearly finished but I am stuck on thge Following.
I need to Update the Date Due and Due Time fields but in different ways.
Fields
Submitted Date, Submitted Time - These are set with an Initial Value of =Now() and disabled.
Due Date and Due Time are the fields I need to Update depending on whih of the Services below is Selected.
We Offer 3 Services
1 - Standard Printing which is 2-3 Days - I would want to make this at Least 2 days after the Submitted Date but it will be enabled as the user can change it.
2 - 24 Hour Printing - Just Add 24 Hours after Submission Date to the Due Date
3 - Quick Printing (Same Day) - If before 10:30am the Due Date set to Today and Due Time would be set to 12:30am. If after 10:30am Due Date set to today and Due Time Set to 15:30. If after 12:30 Due Date set to next Day and Due Time Set to 12:30.
I do not really know where to start with the If statement or whether I should be using Javascript or XBasic. Any pointers in the right direction would be greatfully received. I have searched all morning but not really got anywhere.
Thanks in anticipation
Chris
Let's see if I can explain what I want.
I am putting to together a Printing Requistion System (Fancy Title) whereby Staff fill in a Grid and Upload the file to the Print Room Operator.
All is going well and is nearly finished but I am stuck on thge Following.
I need to Update the Date Due and Due Time fields but in different ways.
Fields
Submitted Date, Submitted Time - These are set with an Initial Value of =Now() and disabled.
Due Date and Due Time are the fields I need to Update depending on whih of the Services below is Selected.
We Offer 3 Services
1 - Standard Printing which is 2-3 Days - I would want to make this at Least 2 days after the Submitted Date but it will be enabled as the user can change it.
2 - 24 Hour Printing - Just Add 24 Hours after Submission Date to the Due Date
3 - Quick Printing (Same Day) - If before 10:30am the Due Date set to Today and Due Time would be set to 12:30am. If after 10:30am Due Date set to today and Due Time Set to 15:30. If after 12:30 Due Date set to next Day and Due Time Set to 12:30.
I do not really know where to start with the If statement or whether I should be using Javascript or XBasic. Any pointers in the right direction would be greatfully received. I have searched all morning but not really got anywhere.
Thanks in anticipation
Chris
Comment