Replies

Try this.

Give a RangeName to the cell where you will enter the range to sum.
Then use this:=SUM(INDIRECT(CLEAN(text))). Where text = cell containing range to sum.

Regards,

Nick

You should create a query where you will create a field for the sum of those two fields and then after in a form or report with record source based on that newly created query you will filter info based on your dept or whatever you want.

Regards,

Nick

Hi,

please verify you variable (if integer make it double) or check if you don’t have a string format instead of a number.

Regards,

nick

Hi,

add grouping in your report. Each time a new item is ‘dicovered’ a total is done in the footer of the group. It will look like:
In detail part of the group add your items in text boxes (TextBox ControlSource = FieldName) and in footer add also text boxes with the control source set to =Sum(fieldname).

Hope it helps,

Nick

Hi,

At my knowledge the answer is no. But, what do you need an array formula in Access if I may ask?

Regards,

Nick