How to transfer the result of a consultation SQL for a matrix and a file text?
I have a Table in Paradox with the following fields:
Field Type Size
Code char 3
Valor1 num 12
Valor2 num 12
Valor3 num 12
With these fields, I want to generate a consultation SQL, grouped by the first digit of the field code with the totals for each digit of the fields Valor1, Valor2, Valor3. After generating the consultation, I want that these total ones are transferred for a matrix and a file text, with the accumulated values of the fields and the digit regarding these values.
How can I make this?