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! 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/
