Forum Discussion
help needed on simple maths in Access
KellieJean-in-Newie It is not possible. 104 = 2 * 52
So something else (that you don't tell) is going on.
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.
KellieJean-in-Newie That's enough information to offer an opinion.
In a list box or combo box, columns are indexed from left to right starting with 0 (indexes being 0-based).
In a typical list box or combo box, column(0) is usually bound the Primary or Foreign Key field in the rowsource for that list or combo box. Column(0) is also usually made zero width, so that it remains hidden to the user; it's there but not visible. Column(1) is usually the one that users see; again, it's actually the second column in the rowsource.
So, here, by switching from column(0), which is bound to the Primary Key, to column(1), which is the value displayed to the user and the one you actually want to use in the math formula, you are no longer using the Primary or Foreign Key for the record in further calculations to get the right record from which to take the values.
Does that sound like the scenario in which you are working?
George Hepworth yes it was something like that, whatever I did I got it to work .... thank you