More than one GIFT values =>250 and =>.01

[Jedediah]

I am trying to create a query where the GIFT count is =>2 and one GIFT amount is >$250 and the other GIFT is of any amount.



Not sure how to do this properly, it is an Append Query if that matters.

Thanks for any assistance.

[John_G]

Please clarify what it is you are trying to do. What is the source of the query, and are you appending multiple records each time? Are you working with a one-to-many relationship (it does look like that), where two or more "GIFT" records are related to some other record?

Thanks

John

[Jedediah]

This is one query of many and I have a total of 34 different queries which create different segments for tracking purposes. This is a one-to-many all gift are related to the ENTITYID field within the tables.

[John_G]

Hi -

The gifts are related to one entity - that makes sense. But where is the data to be appended coming from? The query will INSERT into something ... SELECT data from somewhere or INSERT into something ... VALUES (...)

So we need to know what the something and somewhere actually are.

More details, please.

John