While statement (1 Viewer)

[Lady Gragor]

In Access 2003 I'd be interested to know any oppinion of the best way to manipulate a linked text file to do the following:-

WHILE

Field2 remains the same
AND Field4 remains the same
AND Field5 remains the same

THEN

SUM Field12

ENDWHILE

 

[Pat Hartman]

Use a totals query.

Select field2, field4, field5, sum(field12) as SumOfField12
From your table
Group by field2, field4, field5;