Re: OpenOffice Base - Multiplying Columns

2013-01-25 Thread Kay Schenk
Hello Eric -- You might find additional help on your problem on the OpenOffice Forums, particularly in the Tutorials section for Base. This said, I am not really familiar with the macro writing capabilities of OpenOffice and how/if this applies to Base, but I do know how this would be done w

Re: OpenOffice Base - Multiplying Columns

2013-01-23 Thread Mechtilde
Hello Eric, two comments: 1.) In general there is no reason to store calculated values in a databse. 2.) the basic programm doesn't contain informatioens about the data cells which you want to compare or fill. Kind regards Mechtilde Am 23.01.2013 20:29, schrieb Eric Meyer: > I would like to

OpenOffice Base - Multiplying Columns

2013-01-23 Thread Eric Meyer
I would like to multiply a column based on one of two values, depending upon whether or not a boolean value is true or false. Specifically, if I select Used as true, I would like my margin to be multiplied by .35. Otherwise, if it is false, then I would like my margin to be multiplied by .3. I wo