Forum Discussion
Solved
help needed on simple maths in Access
Hi all - I'm really stuck and need some help. Warning = novice Access user here 🙂 I'm trying to add a calaculation to a query - when I try to multiple a field by a number I get a calculation tha...
KellieJean-in-Newie It is not possible. 104 = 2 * 52
So something else (that you don't tell) is going on.
KellieJean-in-Newie It is not possible. 104 = 2 * 52
So something else (that you don't tell) is going on.
- Thanks to all, i worked out the problem. It seems the field was calculating on the ID rather than the value. Got it sorted but probably not in the ideal way lol.
Maybe if you shared the solution you came up with someone could help you improve it. Or, confirm for you that it's at least an effective solution as is.
Thankyou George Hepworth. I'm not sure I even know what I did to fix it! Looked up whatever I could online - recall something about columns setting, changing the first to 0. Sorry I can't add further.
