Trying to get a assignment done and we have been cursed with Access.

Trying to compile a query where:

Display the total amount each club has spent on band booking fees. You will firstly need to calculate the booking fee

The problem with this, we have 

Multiple Bookings at the clubs, so when I run the query, without the calculated field, just the booking fee for each booking, I get multiples.

Am I making any sense?

Just some help in general would be good. 

Thanks Guys