summation

[Import Text File]

can i sum some data with its repetions
as for example
100
100
30

it gives me 130

 

[Duane Hookom]

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;