Count functions

[hazell]

HI,
With the help of people on this fabulous forum I have created a number of tables. I have one called people and a number of tables for different events. I have populated the events tables by using a lookup of the people table and now I want to total the number of people at each event. (Apologies if I haven't explained this well enough).
I want to have a total attendance column at the end of the table that counts the number of names in the event table but I don't seem to be able to get it to work.
Can you please assume I know nothing and spell out a solution in baby IT language
thanks

 

[plog]

I want to have a total attendance column at the end of the table...

Don't do that. You don't store calculated values, instead...you calculate them. This means you set up a query to add all that data together and run the query when you want the totals.


Here's a link to how to set up a totals query: https://support.office.com/en-za/ar...-a-query-430a669b-e7fd-4c4b-b154-8c8dbbe41c8a