If Function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tk - 25 Jan 2007 19:00 GMT

i want to add a if function to a report. However Im not sure how to do
it.

If the date of a course is greater than a month then i want it to
display the message:
"Please not that this invoice contains payments which have been
outstanding for over three months."
But if its not then i do not want it to display anything

Reply to this Message

Pendragon - 25 Jan 2007 20:22 GMT

Create a text box on your report with the following for your data source:

=iif([CourseDate]<Date()-31,"<<Type your message here>>","")

I assume that you mean if the course date is older (greater) than 30 days
past the current date, you want the message to appear.

You can change or set your reference date to any field by substituting that
field name for Date(), or extend the range, obviously, by modifying 30 to
whatever range you want.

> i want to add a if function to a report. However Im not sure how to do
> it.
[quoted text clipped - 4 lines]
> outstanding for over three months."
> But if its not then i do not want it to display anything

Reply to this Message