if statement

[ATB]

Hi all.

Try this one for size,

i have a report which holds the fields [invoice date] and [due date]

[due date] = [invoice date]+30

I also have a check box [overdue] which i want to have the criteria that:

If [due date] >date() then [overdue]= true

or

If [Invoice date] + 30 = or > date() then [overdue] = True


Please can you point you in the right direction.

Thanks you clever people.

 

[yellow]

Presuming you just want to display this in the report and not store the data....

In the Check Box Recordsoure put:

=IIf([due date] >date() or [Invoice Date]+30 >=Date(),True,False)

Hope this helps...

 

[ATB]

DON'T GET IT!!

thanks for the reply but..

when you say put the code in the recordsource would this be the same as control source. I am using access 2K?

Do i use the code just as you typed it or do i need to disect it. IE. do i need both calculations?

thanks again

 

[ATB]

cRACKED iT

IGNORE THE ABOVE.

MANAGED TO GET IT TO WORK USING YOUR CODE

THANKS A LOT