I have a table with Quant
and Preço
.
In the form, besides these fields, I have the field Total = [Quant]*[Preço]
Also, in the main form I have the field SomaTotal = Soma([Total])
That is, the classic sum of prices that everyone knows how to do.
Question:
How do I put this total in a Sales list?
That is, I have this total for each sale, but I needed a list that would return all the sales, and the total for each one.
Would I have to do a nested query?
The image is illustrative. I need this list in MS Access.