SELECT DISTINCTROW Donations.Donor, Donations.Date, Donations.Amount
FROM Donations
GROUP BY Donations.Donor, Donations.Date, Donations.Amount;
I have a very simple query, listing all of the donations in my donations table.
How do i get the total of all donations on this query, or does it belong somewhere else?
It belongs somewhere else.
Where that is depends on what you're trying to do.
In a report or form, you can have a (some) summed field(s) which can tally your data.
It's possible, though fiddly, to include it in a query, but unless that's necessary do it in a more logical way.
Comment