D
David
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
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