Total query

[Basketball27]

I want to make Total person night
Tried to do (Total adults + kids) * no of nights but that isn't right
I have to count every line and then SUM up to get correct results but do not know how to do it. Any ideas

 

[Alansidman]

In a query in a new field type

Total: ([Adults]+[Under15s])*[Nights]

Use this query as the record source for a new query. In the new query create an aggregate query to sum the total Field