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.