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])