Problem with MS Access Code - TechRepublic
General discussion
November 17, 2003 at 05:38 AM
munrrob

Problem with MS Access Code

by munrrob . Updated 22 years, 7 months ago

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?

This discussion is locked

All Comments