I need to test each transaction listed in a Transaction table to find out if
, as of "today",at least 14 days have past since the date listed in the
"ClosingDate" field. If this is true I want to have a "yes" show up in a
field called "is commission eligible to be paid?"

I also may need to test for other conditions in order for the yes to show.

I am totally at a loss for the proper way to put the expressions together.
Any help would be greatly appreciated.

Barbara:
The simplest way to do this is to use an update query.
basically you need to use the DateAdd function to generate the 14 days
past date and then compare that to the current date.
If that is all you need the query will work and I'll send you a sample
if you tell me what version of Access you have.

If you have other conditions you might still be able to do it in a
query or you might ndeed a bit of code.

Tell me more about the other conditions.

Good luck
Ira Solomon

On Thu, 30 Jun 2005 20:05:06 -0400, "Barbara Warszycki"
<bjw3kids (AT) aol (DOT) com> wrote: