|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 28th, 2007, 05:55 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Access Function like Excel TRUNC function?
Is there an access function that performs the same action as the TRUNC
function in excel? The round function doesn't work for my needs. Don't need to round up, just lose the decimals. 
|
|
#2
February 28th, 2007, 06:31 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access Function like Excel TRUNC function?
Lose the decimals by Integer function --
Int([YourField]) -- KARL DEWEY Build a little - Test a little "Cyhill" wrote: Is there an access function that performs the same action as the TRUNC function in excel? The round function doesn't work for my needs. Don't need to round up, just lose the decimals.
|
|
#3
February 28th, 2007, 07:02 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Access Function like Excel TRUNC function?
Cyhill wrote:
Is there an access function that performs the same action as the TRUNC function in excel? The round function doesn't work for my needs. Don't need to round up, just lose the decimals. Try using the Int or Fix functions. -- Marsh MVP [MS Access]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
