I'm trying something totally new to me here
I have a two controls on a continuous subform the row source for both is a query and Column(2) is a Name, Column(3) is a number.
These are displayed by setting Column Count and Column widths to suit.
The whole picture is - the Main Form will have a Calculated Value
I want to enter a number of entries in the subform and depending on the value allocated to each Name (location) I will then allocate a portion of the Total Cost to each name.
It's taken me ages to get a cascading combos where the 1st is on the Main and the Second is on the subform now I cannot total this value on my subform so until I can do this I cannot get a percent to allocate each Location Cost (does this make sense)
I'd hoped this might work but I don't think Column count can be used in an expression
=Sum([DestinationNo].[Column](3))
Also the subform record source is not the table where the values are stored which I feel is part of the problem