Here's a very interesting one for the experts. I've been battling this for the last week with many attempted solutions.
I have a MSAccess DB (2013) with the following tables.
I want to find the current DLevel for each customer by using the SUM of their Points in the first table. I have this first...
SELECT SUM(Points), CustomerID FROM PointsAllocation GROUP BY CustomerID
Works well and gives me total points per customer. I can then INNER JOIN this to the customer table to get the persons name. Perfect.
Now I want to add the DLevel from the DanceLevel table to the results where the SUM total is used to lookup the Threshold and not exceed the value so I get the following:
100 3 Intermediate
101 5 Advanced
102 1 Beginner
... and so on.
Any ideas anyone?