Need Help With Date

[sweetfee]

I'm New To Access.
I Have A Form That Has The Date That The Customer Membership Fee Is Due If The Fee Isn't Pd By This Date I Would Like The Label Visible Showing The Text 'overdue'

Help Please

[RedSon]

I'm New To Access.
I Have A Form That Has The Date That The Customer Membership Fee Is Due If The Fee Isn't Pd By This Date I Would Like The Label Visible Showing The Text 'overdue'

Help Please

Is this an Access database question?

[pbmods]

Heya, sweetfee. Welcome to TSDN!

I'm going to go ahead and move this thread to the Access forum, where our resident Experts will be better able to help you out.

[missinglinq]

We need some more information if we're to help you, like:

• The name of the control holding the Payment Due Date
• How is the fact that payment has been made or not made noted in the record

Welcome to TheScripts!

Linq ;0)>

[lee123]

you could do this in the controlsource of the label your using and an (IIF) statement like this
[code=vb]
=iif(duedate=wh at ever you named the date box,"Due","NotD ue")
[/code]
lee123

[pbmods]

Heya, lee123.

Please use CODE tags when posting source code:

[CODE=vb]
Source code goes here.
[/CODE]

[lee123]

yea got ya!

lee123

[missinglinq]

[CODE=vb]=iif(duedate=wh at ever you named the date box,"Due","NotD ue")[/CODE]

Comparing the Due Date against, say, the current date, will show you whether the due date has passed or not, but it won't show you whether the dues have been paid! The OP wants the PastDue label to show if the due date has passed and the dues haven't been paid! As I said in my previous post, we need to know how the payment of the dues is noted in the record.

Linq ;0)>

[sweetfee]

thanks i figured it out