By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,826 Members | 2,443 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,826 IT Pros & Developers. It's quick & easy.

Simple total, where do I stick it in my query

emandel
P: 65
Expand|Select|Wrap|Line Numbers
  1. SELECT DISTINCTROW Donations.Donor, Donations.Date, Donations.Amount
  2. FROM Donations
  3. GROUP BY Donations.Donor, Donations.Date, Donations.Amount;
  4.  
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?
Jan 3 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,489
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.
Jan 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.