I am new to MS Access and to monetary fields and I am wondering if there are any special considerations that I have to pay attention to when design and program such fields?
Some initial questions in my head for the database that has multiple currencies.
What is the best data type for the fields that has monetary data?
Is it Number or currency? and what should be the variable type in vba that can hold such field data?
Initially, I made two separate fields on as a Number and the other one as a Number too that should be related to currency table.
According to Currency field in the form the monetary fields will be formatted.
Is this OK?
Would the calculations be correct? because I hear that monetary fields should have some special considerations to keep the money calculation correct 100% ?
Any other considerations I did not mention?
Thanks in advance.