Okay I lied

[Guest]

One more thing. If its possible. Employee benefits start on the first of the
month after the date of hire if an employee is hired before the 15th of the
month and the first of the following month if hired after the 15th. Is this
possible?

 

[Guest]

There are several differnt ways to handle these.
Look here for some Date/Time functions:

http://www.mvps.org/access/datetime/index.html


jmonty