Decimal data types and Calculated fields in DAO.recordset (build 16.0.12827.20152)
Anyone having problems with DAO.Recordsets and calculated fields in the latest Insider update (16.0.12827)
So long I found:
When accessing a table field with "Decimal" data type, recordset returns empty string... Changing the data type to double fixes the issue
When accessing a query calculated field (sum) the DAO.Recordset returns empty string... Adding the CDbl to the query field fixes the issue.