Displaying a status

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam - 12 Jul 2005 03:14 GMT

Hello

I am trying to create a Loan application tracker that prompts the user to
complete a particular task based on the status the application is in. For
EG...

User is waiting on the return of loan contracts from customer.

If status = "Waiting" and has been waiting for more than 3 days, then a
prompt some like "chase up contracts" is to appear in a box.

I was able to make this task work in Excel, however the formulae used in
Excell cannot be replicated in Access.

Hope some one can help me.

Regards

Reply to this Message

Marshall Barton - 12 Jul 2005 04:29 GMT

>I am trying to create a Loan application tracker that prompts the user to
>complete a particular task based on the status the application is in. For
[quoted text clipped - 4 lines]
>If status = "Waiting" and has been waiting for more than 3 days, then a
>prompt some like "chase up contracts" is to appear in a box.

Add a text box and set its control source expression to:

=IIf(Status = "Waiting", "chase up contracts", Null)

Signature

Marsh
MVP [MS Access]

Reply to this Message

Sam - 12 Jul 2005 09:04 GMT

Thanks Marshall. Works fine!

> >I am trying to create a Loan application tracker that prompts the user to
> >complete a particular task based on the status the application is in. For
[quoted text clipped - 8 lines]
>
> =IIf(Status = "Waiting", "chase up contracts", Null)

Reply to this Message