This seems simple enough and maybe I am making things just extremely difficult. I have a table with just the persons name, full payment amount and a commission %. All I want to do is run a macro to compute the Total Check amount * the person's commission % to = the end commission check amount and place that amount in another table. I cannot seem to get the expression builder to work. Can anyone help: here is a breakdown of the commission formula: NAME, FULLAMT*%AMOUNT=PERSONS COMMISSION $ AMOUNT.

Do not save your results in a table. Create a form that shows both the Commission and the FullAmt.

Add an unbound text box and in its control source type

=[Commission]*[FullAmt]