Building an Access database normally starts with tables and getting the right data types in Access early on will save a lot of headaches later when calculation and referring to numeric values elsewhere. Currency and Number data types are different to each other and the flexibility, scope and application use will help you to make to right choice. Here’s a quick checklist: Is the value going to be a monetary process? How many decimal places are required for the field? […]

Tags: access table data types, currency data type fields, data types in access, microsoft access database, microsoft data types, ms access help