I am trying to make it so that if the value that the first part of the expression is less than 1, then a message "subscription ended" comes up, however this isnt working any suggestions as to why wud be gr8!

DateDiff("y",[Magazine Records]![Current Date],[Magazine Records]![Date Subscritpion Ends]) And IIf([days left]<1,"subscription ended","«falsepart»")

Try:

Iif([Magazine Records]![Date Subscritpion Ends]-Date())<1,"Subscription ended","«falsepart»")

Date(): Return the current date on the PC

Using "y" will give the number of years difference between the days not the number of days.

Also you have a spelling mistake in your field name: - ([Magazine Records]![Date Subscritpion Ends]

Hope that get you part way.

Ian


[This message has been edited by Fornatian (edited 08-04-2001).]