Query help

[dlburkins]

I have a simple table and I have two columns: "ACD Calls" & "ConversionsACDcalls". The problem is is want to strip all data where ACD calls is less than 100 & ConversionsACDcalls are greater than 0.000.



The problem that i am running into is that if I use the criteria for each column, it treats each condition seperately and not as a unit. If the data meets the two conditions above I dont want to see it when I run the query.

Thanks

[pbaldy]

It sounds like you have "OR" between the conditions rather than "AND" (on different rows in design view). What is the SQL of the query?

[dlburkins]

WHERE (((SMpayout.[ACD Calls])>99) AND ((SMpayout.ConversionsACDcalls)>0));

The problem with the query is that if i have ACD Calls less 99 but ConversionACDcalls greater than zero it strips it from the data.

For example: if you have someone with 67 ACD Calls and ConversionsACDcalls of .030 it dosent include them in the data sample. But I would like this one to be incuded because the ConversionsACDcalls is greater than zero eventhough there is less than 99 ACD Call this person.

I only want to exclude those that have less than 99 ACD calls & 0 ConversionsACDcalls. Only if the data meets these two conditions should it be removed from the data sample.

Thanks

[pbaldy]

Did you try changing the AND to OR?

[dlburkins]

Thank you i didnt know that it was that simple. I am still learning my way around SQL & Access

[pbaldy]

No problem; there's a lot to learn. Post back if you get stuck.