Calculation in SQL

Alright moishy, I've amended your query so it returns the results you expected. Also, I created another query called qryDonations2 which shows you a different way of reaching the same goal by using a Crosstab query.

Have a look and let us know.
 

Attachments

One problem left, if a donor doesn't have record for each the columns (years) that donor won't show up, can that be changed?
 
Wow! couldn't ask for more!
But you just did :p

Have a look at your Date criteria, it's restricting Null values from showing up. Also, you will need to change the joins between the details table and the other two tables so that it picks up ALL records from the details table.
 
Have a look at your Date criteria, it's restricting Null values from showing up.
How can I change that in the above query?

Also, you will need to change the joins between the details table and the other two tables so that it picks up ALL records from the details table
How do I do that?
 
How do you include Null records in a query? This is basic stuff. Have a good think.

You need an Outter Join. Look at the properties of the Join itself.
 
You just need a nudge in the right direction.

Good work!
 

Users who are viewing this thread

Back
Top Bottom