Returning multiple criteria query result

[fiveupnorth]

Hello.



I work for a non-profit and I have a query where I need to return all Gift Types. The exception is we only want Pledge Gift Type that are greater than $1000.



Anyone able to help me?

Kim

[JoeM]

Do this on two Criteria lines:

1. One the first one, under "Gift Type", enter:

<> "Pledge"

2. On the second criteria row, enter this under "Gift Amount"

> 1000

[fiveupnorth]

When I added that it returned only Gift Amounts greater than 1000 (there are many less than that I need to show up) and it did not return the Pledges even though they were >1000.

[JoeM]

You put both on the same Criteria row. As I said, they must be put on TWO (different) Criteria rows (notice all the blank rows they give you!).
See here for a visual example: https://support.office.com/en-us/art...C-7E37189EDE88

The way that Access works, is multiple conditions placed on the same row are treated as "AND" conditions, while ones put on different rows are treated as "OR" conditions.

[fiveupnorth]

I see! Thank you.

Last question, can you have two AND Conditions and one OR? I have one other parameter and that is deceased is equal to No. When I add the two above, by deceased donor appears on the report.

Thanks again!

[JoeM]

You certainly can, but it needs to be well thought-out.
If you are adding "exclusions", you need to look at every row where you have conditions. If the condition on that line does not already exclude that person, you need to add the exclusion to that row.
It may mean adding the exclusion to every row that you have conditions.

[fiveupnorth]

Got it to work. Thanks again.

[JoeM]

You are welcome.