Array functions in Access Fields (Tricky one)

[SebastianColombia]

Good morning/afternoon/evening: I was wondering if you can help me with the following: I'm trying to create array functions which would take as argument, the fields in my tables. I'm trying to create the kind of functions you would in Excel by typing ctrl+shift+enter. What I nedd these functions to do is something like COUNTIFS, AVERAGEIFS, SUMIFS, MAXIFS, and many other functions like that. Is this possible in ms Access 2013? Is there a manual I could use to create these kind of functions?

I'm attaching an example of what I would like to do. The table in the Excel file contains blue columns that are the columns in my Access table. The orange columns are the CALCULATED FIELDS I would like to insert!!!. Since the number of records in my table are going to be growing, I need the calculated field to dynamically update and take all the fields.

I would really appreciate if you could help me!!!!

Thanks Access gurus

[ranman256]

you do this in a query, with
COUNT, AVG, SUM, MAX

count([field])
max([field])

[June7]

Research aggregate GROUP BY (Totals) queries. Use the query builder. Basic Access functionality.

Alternative is to build a report using its Sorting & Grouping features with aggregate calcs in group header/footer sections. This allows display of detail info as well as summary calcs.

You would not have fields in table that require updating. These calcs would be done when needed by opening query or report.