Recent content by Zdiane

Worked Excellent!!!, So Much Appreciated .. :)

Thnx for reply :) The [DateRented] is set to Short Date & also the [DueDate] Field , This was the original I was working =IIf([Due Date]<Date(),"OVERDUE",IIf([Due Date]=Date(),"Due today","Not Yet Due")) (From Microsoft Access Site) but found it to return opposite results If I use this...

Hi all, First Post :) I am currently trying to make a database based on a Video Shop for my ITQ course and I am completely confused why my IIF statements wont show the dates to equal todays date: I am Using Date Add to give me a date 2 days+ DateDue: DateAdd("d",2,[DateRented]) then using...