I am trying to get a number as a result of a division in query builder but want to only show the whole number part of the result. The code I am using to do this is:
Wait in Months: Left([KDays]/30.41,(InStr(1,CStr([KDays]/30.41),”.”)-1))
but I get an invalid procedure call error. Can anyone tell me the correct syntax?
