Display numbers to the left of a decimal sign

[AccessIM]

I am trying to break down a calculated field ([CasesSold]) to display only
the numbers to the left of the decimal. I am using the line below based off
similar entries found in other discussion groups but the results are not
correct.

FullCasesSold: Left([CasesSold],InStr(1,[CasesSold],".")-1)

The results for field value of 0.25 is correct in that it shows 0 but they
are not all correct. For example, 0.08 shows 8 as the value and 1.00 shows
an #Error.

What am I doing wrong? Any help is greatly appreciated.

 

[KARL DEWEY]

Try this ---
FullCasesSold: Int([CasesSold])

 

[AccessIM]

That worked perfectly . . . and so easy! ) Thank you so much for the quick
response.

Try this ---
FullCasesSold: Int([CasesSold])

--
KARL DEWEY
Build a little - Test a little

I am trying to break down a calculated field ([CasesSold]) to display only
the numbers to the left of the decimal. I am using the line below based off
similar entries found in other discussion groups but the results are not
correct.

FullCasesSold: Left([CasesSold],InStr(1,[CasesSold],".")-1)

The results for field value of 0.25 is correct in that it shows 0 but they
are not all correct. For example, 0.08 shows 8 as the value and 1.00 shows
an #Error.

What am I doing wrong? Any help is greatly appreciated.