Thank You All for help.
- Rajeev
--- Trent Johnsey <[EMAIL PROTECTED]> wrote:
---------------------------------
Just as a suggestion.
As none of us will ever know for certain how the
applications we build today
will be used tomorrow, I highly recommend using double
for 'currency' fields.
Currency is a non-standard field type in the world of
database development.
As the topic here is rounding down, the following
thought doesn't apply, but
these arguments should be considered before using
currency as a field type.
1. Currency only allows 4 decimals. Decimals values
beyond 4 will be
truncated from a currency field.
2. If at some point in the future the database will
need to be converted to
MySQL or some other SQL format, currency doesn't
convert properly because this
data type doesn't exist in true SQL RDMSs. If the
data is already double, then
any conversion will go very smoothly.
3. Currency as a data type is a MS Access only
entity.
Just food for thought.
TJ
--- Richard <[EMAIL PROTECTED]> wrote:
> If you are exporting to an accounting system, why
not use
> the "currency" data type (table defs window)? This
will auto-round to
> 2 decimals.
>
> Just one way...
>
> Richard
> --- In AccessDevelopers@yahoogroups.com,
"angusnisbet" <[EMAIL PROTECTED]>
> wrote:
> >
> > 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.
>
>
>
>
__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
Please zip all files prior to uploading to Files
section.
SPONSORED LINKS
Microsoft access developer
Microsoft access help
Microsoft access database
Microsoft
access training
Microsoft access training course
Microsoft access programming
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AccessDevelopers" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.
---------------------------------
__________________________________________________________
Yahoo! India Matrimony: Find your partner online. Go to http://yahoo.shaadi.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
