combine 2 functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Johnwats - 18 May 2008 12:33 GMT

On a Form i have 3 boxes to keep check on students progress, 1) Course
started, 2) Course completed, 3) Days in progress. Once i have entered a
date in box 1, i can enter a DateDiff function in box 3 & that works fine.
But when i enter a completed date in box 2, i want the Days in progress box
to stop counting. I have been told to use a DateDiff & IIf functions
combined, but i just can't get the syntax correct. Any help appreciated.

John W

Signature

Johnwats

Reply to this Message

Linq Adams - 18 May 2008 13:47 GMT

What code placed where are you currently using?

>On a Form i have 3 boxes to keep check on students progress, 1) Course
>started, 2) Course completed, 3) Days in progress. Once i have entered a
[quoted text clipped - 4 lines]
>
>John W

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message

Johnwats - 18 May 2008 22:13 GMT

I am entering the function in the "days in progress" box. But can't get it
to stop counting to the current date, even when there is an earlier date
entered in the "completed" box.

Signature

Johnwats

> What code placed where are you currently using?
>
[quoted text clipped - 6 lines]
> >
> >John W

Reply to this Message