Simple total, where do I stick it in my query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • emandel
    New Member
    • Dec 2006
    • 65

    Simple total, where do I stick it in my query

    Code:
    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?
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32636

    #2
    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

    Working...