Building a syntax for Billing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following syntax :
=IIf([dt_started]<> "12/07/2005", "12/01/2005")
I am using this in a objects form connected to my database with three other
fields called [dt_started], [dt_closed], and [billing_days]. I have the date
closed and the billing days syntax already done, and It will give me all the
accounts started prior to the billing month and make it a default value of
12/01/2005 for billing purposes, but it will not take an account that started
12/04/2005 and terminated on 12/7/2005 and give me a billing day of 4 days????

Any help would be appreciated.......
 
DateDiff is a function for adding and subtracting dates. Check Help and give
it a try. Some apparent problems in date calculations can result from people
using the Now() function which includes both date and time, instead of the
Date() function which populates only the date portion of a Date/Time
Variable or Field.

If you are billing by the day, you'll need to account for weekends and
holidays. If you Google on "working days" or "work days" in the archives of
this newsgroup and of comp.databases.ms-access, I suspect you'll find some
useful information on calculating working days.

Larry Linson
Microsoft Access MVP
 
Back
Top