Access Database: Number Display

[catz]

Good afternoon,

I'm trying to display a number in a field to only display the number(s) to the left of the decimal point. For example, 10.567 should display as 10;
5.987 should show 5.

I've tried all kinds of things using LEFT to no avail.
Can someone help please?

Thanks for any assistance.

[Sidewinder]

The question is murky. Any ODBC aware language can process an Access database and we have no idea what language you're using.

If by chance you're using a member of the VB family (VBA, VBS, VB, VB.NET), check out the fix and int functions.

The difference between Int and Fix is that if number is negative, Int returns the first negative integer less than or equal to number, whereas Fix returns the first negative integer greater than or equal to number. For example, Int converts -8.4 to -9, and Fix converts -8.4 to -8.

Source: Windows Scripting Technologies

Good luck. 

[soybean]

Good afternoon,

I'm trying to display a number in a field to only display the number(s) to the left of the decimal point. For example, 10.567 should display as 10;
5.987 should show 5.

I've tried all kinds of things using LEFT to no avail.

What database objects have you created so far?  Only tables?  Queries?  Reports? 

Formatting numbers for display in a Query is easy.  Have you ever created a Query?