Need help Modifying a query expression

[leslina76]

I have a query expression that shows me how many months are left on all our company loans. It works great, however I need to modify it where (if the loan end date is in the past to just show 0). I could easily do this in excel by have no clue in Access. My query does show 0 if my loan end date is 04/01/2010 to date() "today" but once the month changes to June 2011 it will show -1, July it will show, -2 so on so on. So my only issue is telling it that anything less than 0 should always stay at 0. These negatives are screwing up my calculations. It seems to simple yet I'm stumpted. HELP!

Current expression below:
Months Left: DateDiff("m",Date(),[loan end date])

[ssanfu]

Here are 3 different ways to force a negative number to zero:

1) Months Left: IIf(DateDiff("m",Date(),[loan end date])>0 ,DateDiff("m",Date(),[loan end date]),0)


2) Months Left: DateDiff("m",Date(),[loan end date]) * ABS((DateDiff("m",Date(),[loan end date])>0))


3) Months Left: DateDiff("m",Date(),[loan end date]) * (DateDiff("m",Date(),[loan end date])>0) * -1

[leslina76]

Great! Thanks. I'll give it a try and post the results. Thanks for taking the time to help me. I really appreciate it.

[leslina76]

It worked, thanks so much!