How can I calculate the sum of multiple elements when they have different values ?

[Bseb]

Hey! Bit new. Sorry if the title seems vague, I don't know how to better phrase it.



I wanted to ask if I can make a field that shows me the sum of a+b+...+n just by inputting the number of variables in another field.

Like I have a field: NumberOfEmployees
And another: TotalValue

If every employee has a different value atributed to them, what method would be used or what formula would I use in the TotalValue field to calculate the value based on the NumberOfEmployees field ?

[June7]

That makes no sense to me.

Show example of raw data and the desired output.

[Bseb]

Ok, let me try and explain. I have a form. The form has 2 fields: NumberOfEmployees and Value

employee number: 1 | 2 | 3 | 4 | 5 | 6
Value($): 10 | 25 | 50 |100 |170 |280

I need to calculate the sum of Value by imputing the number of employees. So if I put in a specific field the nr. 3, then it would calculate in another field the sum of 10+25+50 and output a result

Did manage to be more specific ?

edit: Oh wow, the formating of the post does not help my case at all...

[June7]

More post formatting tools in the Advanced editor.

Still confused. What happens to 100, 170, 280 values?

If you want to limit the calc to just 3 records, need some filter criteria.

[Bseb]

Nono, the calculating 3 records was just an example. I need it to return the sum of the records that I input in my number field. If I put 4, it will calculate the first 4 records, if I put 10, it will calculate the first 10 records, etc.

I just don't know the formula to make the program calculate the total records from a to n if I input n.

[June7]

What do you mean by 'input in my number field' - is this an unbound textbox on form for input of criteria? Because inputting this into a field of table is not useful.

Do an aggregate GROUP BY query with whatever criteria is used to limit dataset.

Can use TOP N parameter to limit query to a specified number of records, otherwise need some kind of filter criteria.