Do you need to actually round before storing the data, or can you round at
the point of exporting to an accounting system?
Also, you can building your own rounding function using the Int function.
For example
' Rounds amt argument to two decimals
Function Round2Dec(amt) As Double
Round2Dec = (Int((100 * amt) + 0.5)) / 100
End Function
HTH,
Toby
----- Original Message -----
From: "angusnisbet" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, October 10, 2005 3:26 PM
Subject: [AccessDevelopers] Store number to 2 decimal places
> I have built a number of databases, generally for various financial
> purposes, and there is a recurring problem which perhaps some of you
> can help me with.
>
> How can I store numbers to a maximum of two decimal places? This can
> have serious consequences when exporting data to an accounting system.
>
> The various Number data type settings deal solely with how it is
> displayed, not how it is stored, likewise the Currency data type.
> The Input mask does not seem to do a satisfactory job and besides many
> of the values are calculated. Why isn't there a Round() function?
>
> Thanks for any help.
>
>
>
>
>
>
>
> Please zip all files prior to uploading to Files section.
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
