I've done this a thousand time but must be missing something here. I have just changed to 2007, trying to find the value of the sum of one field in a query.
SQL is as follows:-
Sum(tbl_Variations.[Approved Variations]) AS Total
The result is the individual...