Hi

I have a form which has 3 different comboboxes in it. These comboboxes makes is possible to have multiple choises like customer, Year and month. The result is shown in a Subform set as a table.

So far so good... but is it possible to calculate for example keyratios based on the subform set to be shown as a table. Like sales per customer,year and month?

I tried to calculate the fields in the subform (for example SUM) and so on but I didn´t get it working.

http://www.access-programmers.co.uk/ubb/smile.gif --Thanks-- http://www.access-programmers.co.uk/ubb/smile.gif