|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Hey All,
Does anyone know where I can find a nice online guide that shows the syntax of the expression builder and the access code.
I am trying to be able to code my own formulas that will require "if" statements. I am not sure of the syntax for these commands.
One of the challenges I am trying to tackle is calculating business days and non business days in a date field.
For Example: The form is an order entry form. The order entry date is automatically generated by the date() command, but I would like to generate the delivery date too. The formula date() + 1 works well for Monday thru Friday, but on Saturday it needs to be + 2. The other problem is when a holiday hits. That will throw it off too. I was thinking of having the Delivery date automatically entered from data that was entered in the last order. That way the user would only have to update the first order of the day for the delivery date. The problem with that is if she enters the wrong date once and doesnt pay attention it will be wrong on every record.
Anyone have any ideas on the best way to approach this?
Thanks!
Dave
|
|
|