Recent content by db2

Thanks for all your help Rookie, this is pretty close to what I needed and I've managed to also make several queries that give me the results that I need. One last question though, you said that this should give me a list of past contributors of $100 or more who have not given $100 or more...

I'm trying to figure out how to query to get the max donation date of a customer. I want to say: max(Donations.DonationDate) < 04/01/2007 When I try to perform the above in the criteria field it says "Aggregate Functions Cannot be used in a WHERE clause". I need to find people who have not...

Ok, Because in this latest query that you provided it is showing me all the donations over $100 made before the max don date, but some of the donors in that list have donated after the MaxDonDate, it's just not including those donations in the query results. I need these people eliminated too...

Sorry to keep asking for clarification. Just trying to understand this formula. So from what I can gather this is giving me a list of all donations over $100 from donors that do not have any donations after the MaxDonDate? It's not just showing me Donations over $100 before the MaxDonDate...

One more question. Wont this: a.MaxDonDate > #01/04/2007# ); Give me people whose last donation date was after 01/04/2007? Shouldn't it be: a.MaxDonDate < #01/04/2007# ); ?

I had to fix a couple little label errors but I ended up with this: SELECT ID, [Donation Amount], MaxDonDate FROM ( SELECT [Contribution Data].ID, Donations.[Donation Amount], Max(Donations.[Donation Date]) AS MaxDonDate FROM [Contribution Data] LEFT JOIN Donations ON [Contribution Data].ID =...

Hi Rookie, thanks for your help so far. Unfortunately I'm stuck in access 2003 so I have to modify your code to get this: SELECT [Contribution Data].ID FROM [Contribution Data] LEFT JOIN Donations ON [Contribution Data].ID = Donations.ID WHERE ( ( Max((Donations.[Donation Amount])) >= 100 )...

Thanks for your help, I'm still pretty foggy on SQL, but with your example and another I came up with this following code. Does this make sense to you? Also, if this is correct where could I add a clause to check if the donor has previously given $100 or more at any time in the past? (or if...

To clarify, I can't figure out how to say "only show id's that do not have donations after 01/04/07".

I have several tables containing information about donors to our charity. We need to send a letter to donors that have not given in the past year, who have also given an amount equal to or larger than $100 in the past. My main concern is the first part. We have a "contributor data" table that...

Bump. Anyone have a suggestion?

That would get me my first list of people, and then I need to subtract from them another list of people, hence my feeling that I need a conditional statement.

Nope, all donation categories are in one field titled "donation type". There is a form for donation entries and we assign donation type via a drop down list.

Sorry, yes there are more categories than a,b,c. It's A Or B Or C. Trying to find people who've donated to specific categories in the past, and eliminate from that group people who have donated in the same categories AND one additional category this year. So it would actually be like...

Hi, I have an access database that contains information on donations made to our non profit organization. I'm wondering how I query for people who have donated in categories (a,b,c) between 01/01/05 - 01/01/07, but have NOT donated in categories (a,b,c) in >01/02/07. In other words I'm...