help with conditional statement

[db2]

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 trying to sort out the people who have donated to us in certain categories in the past, but have not yet done so this year.

There are fields in my tables for donor id, as well as donation type, and donation date.

Any help or info is appreciated!

 

[rainman89]

Couple questions
are there more categories than a,b,c??

and also is it any category? or is it a and b and c?

for the date you can do
between #01/01/05# AND #01/01/07#

 

[db2]

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:

(Donors in cat:a,b,c between 01/05-01/07) - (Donors in cat:a,b,c,d after 08/07)

If that makes sense?

 

[boblarson]

It is sounding like you have each category in a different field, rather than in rows. Is that assumption correct?

 

[rainman89]

ok so put "a" OR "b" Or "c" in the category criteria
and between #01/01/05# AND #01/01/07# in the date criteria

 

[db2]

It is sounding like you have each category in a different field, rather than in rows. Is that assumption correct?

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.

 

[db2]

ok so put "a" OR "b" Or "c" in the category criteria
and between #01/01/05# AND #01/01/07# in the date criteria

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.

 

[db2]

Bump.

Anyone have a suggestion?