Microsoft Access Database Engine: Invalid precision for decimal type

[AlterMini]

I am getting error in my Output Data. Fixed decimal 47.2 is the format in all numeric fields. How to fix the error

[atcodedog05 · Accepted solution]

Hi @AlterMini 

Can you reduce the precision to 15.2 or 10.2 is precision up 47 digits really needed ?

[AlterMini]

Thanks for your suggestion. Meantime I changed format into Double, it works.

[atcodedog05 · Accepted solution]

Hi @AlterMini 

Its actually doing the same thing but your decimal precision may not be 2 digits.

[AlterMini]

Thanks atcodedog4. your suggestions also works. 

[atcodedog05]

Happy to help : ) @AlterMini 

Cheers and have a nice weekend!