Setting an alert that a payment is overdue

[bellevue]

I have a reservation database that holds data for all guests with bookings; in it, I have the folllowing fields:



One for their outstanding balance "Balance 5" (circled red in the attachment)
One that holds the due date for the balance of their holiday "Due Date 2" (circled blue in the attachment)
One for an alert message "Payment" (circled green in the attachment)

I'm trying to create something (possibly an iif argument ?) which will show a message of OVERDUE in the "Payment" field if both of the following are true:

"Balance 5" is greater than £0.00 and "Due Date 2" is less than today's date.

You can see from the attachment that I've had a go but it isn't working, it keeps bringing up the Name error message - can anyone help please ?

[RayMilhon]

A Little clarification. You have the problem in the Payment Field but your showing the textbox for Due Date 2. So we don't have a clue as to what is in the field that you're asking about. Post the Control Source for the field your having a problem with and we may be able to help better.

[bellevue]

Sorry, am new to this...

The control source for the field [Payment] is:

iif([Balance 5]>"0" AND [Due Date 2]>Date(),"Overdue","")

[recyan]

Have you tried :
iif([Balance 5]>0 AND [Due Date 2]>Date(),"Overdue","")

Thanks

[bellevue]

Thanks for that, I tried that and it's still bringing up the "Name" error thingy.

[RayMilhon]

Here's a test to narrow down the error: First Use IIF([Balance 5] > 0,"Overdue","Not Overdue") , second use the second part IIF([due date 2]>Date(),"Overdue","Not Overdue") Make sure which one errors. Then we can narrow it down from there.

[bellevue]

Thanks for that.

I tried them both and they both "error'd"; however, when I put a "=" before both, they, individually, worked fine. I then put the "=" before the original combined argument, it all worked fine...problem solved !!!!

Thank you so much for your time (and patience), I really do appreciate it; I'll mark it as solved but let me know if/how I can show my appreciation.