Calculating values in base

[JeremyAndrews]

Any suggestions of how one can perform arithmetic functions in base forms. e.g. multiply one field by another or setting a column in a table to be equal to two or more other columns. Perhaps a simple macro.

[bencomp]

Could you confirm that you need a form to show a value that is the result of a (real-time) calculation based on input in the same form? Or are you talking about reports?

[qubit1]

Hi @JeremyAndrews, @AlvLin50,

Have either of you found documentation on this subject?

Sounds like you could just use some SQL queries to format/concatenate/etc… your data? E.g. like this:

• http://stackoverflow.com/questions/14922854/make-a-single-record-from-multiple-sql

[AlvLin50]

Hi Sewowg:

I have a similar issue, however, no one has answered. By any chance did you find a solution?

Thanks

Alvin