Other option than OR

[ddtpmyra]

I have a two columns that hold numbers of sales for every month for instance. For every row I wanted to select the records that falls to greater than or equal to 10 sales.

How can I put it on a query.

Ex.
StoreName|May|June
StoreA |5|10
StoreB |10|5
StoreC |5 |5
StoreD |12|1

Query Result must be:
StoreA 5 10
StoreB 10 5
StoreD 12 1

My current condition query is like this

WHERE [May]>=10 OR June>=10

My question is how to make it equal or either any of two columns has 10 or greater

[TheSmileyCoder]

I don't think im following you. You seem to be asking for what your query is allready giving you. Could you try to explain in more detail, or rephrase it?

[ddtpmyra]

WHERE [May]>=10 OR June>=10 
 

Above is the condition I have on my query right now. The problem is it consider first the May columns that has =>10 first before the June columsn. What I wanted is either of the two columns (may or june) has greater equal to 10 is to fetch the records.

currently scenario:
StoreName|May|June
StoreA |5|10
StoreB |10|5
StoreC |5 |5
StoreD |12|1
RESULTS:
StoreB |10|5
StoreD |12|1

Wanted RESULTS:
StoreA |5|10
StoreB |10|5
StoreD |12|1

I hope I explain this very well let me know if you need more further explanation or samples.

thanks!

[TheSmileyCoder]

Thank you, I have a much clearer idea of what you want now, and which parts are not working as expected.

Have you tried using square brackets [] around June?

[ddtpmyra]

Oh no, It's just my typing. But I dont have problem with my query. My problem is how to fetch the records using different ways on my conditions.

[NeoPa]

ddtpmyra:
Oh no, It's just my typing.

That's exactly why you should never type the information for your questions but Copy and Paste it from your work. It takes very little effort on your part and potentially saves a lot of time. A very important point to remember for future posts.

As for your question, it still seems somewhat unclear. Your English is not easy to understand (although I'm sure you're trying to express it as well as you can) so perhaps you can explain what you need and why. If your query already works, why do you need an alternative approach (I think this is what you're asking for). Certainly, like Smiley, I can see no reason why what you already have (assuming it is corrected) would not provide exactly what you say you want.

Maybe it's as simple as using parentheses correctly :

WHERE ([May]>=10)
   OR ([June]>=10)