Group:  Microsoft Access ยป microsoft.public.access
Thread: Expression Builder and Code Editing

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Expression Builder and Code Editing
"David" <david[ at ]dave.com> 26.09.2006 15:06:14
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


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net