Split form, Totals, Calculated field

Hello

I have a split form. Three columns contain currency data. First one, PRICE has different set values, for example 500€. Second one is calculated, PRICE*fieldA in the form. Third one is also calculated, PRICE*fieldB.

I wanted to create totals for those two last columns. However, access 2007 only allows me to do so on the first field. The two other only allow me to select None and Count, although selecting count does nothing.

Any ideas?

Create a query and perform the calculation in the query. Use that query as the record source of your split form.

You can't perform totals (using Sum() or Count()) on calculated fields, but if the calculations are in the record source then it will work.