spaLOGICng
Member
- Local time
- Today, 03:11
- Joined
- Jul 27, 2012
- Messages
- 128
The problem is with the LOG Function, and specifically the "BASE" of the Function, but not a problem at all. It is just the matter of understanding how the LOG Functions work in the two applications.
The default Base for Excel is 10. The default Base for Access is 2.718282, referred to the "natural" logarithm of the n. You will need to write a custom
Access > Log function (Visual Basic for Applications) | Microsoft Learn
Excel > LOG function - Microsoft Support
That said, there is absolutely nothing wrong with your Office installation or VBA in Access.
The default Base for Excel is 10. The default Base for Access is 2.718282, referred to the "natural" logarithm of the n. You will need to write a custom
Access > Log function (Visual Basic for Applications) | Microsoft Learn
Excel > LOG function - Microsoft Support
That said, there is absolutely nothing wrong with your Office installation or VBA in Access.
