Calculation in SQL

[vbaInet]

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.

 

[moishy]

Wow! couldn't ask for more!

 

[moishy]

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?

 

[vbaInet]

Wow! couldn't ask for more!

But you just did

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.

 

[moishy]

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?

 

[vbaInet]

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.

 

[moishy]

Thanks, got it!

 

[vbaInet]

You just need a nudge in the right direction.

Good work!