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/
