From you example, you could create a group by or distinct query and then a
totals query that sums the distinct values.
=== qgrpSomeData ===
SELECT DISTINCT [some data]
FROM [No Name Given];
Then
=== qtotSomeData ===
SELECT Sum([some data]) as SumSome
FROM qgrpSomeData;
