"AND", "OR" and "IN"

[KenshiroUK]

Okay I'm trying to create a query that pulls in data from an order report. What I wish to do is pull in customer orders from a Order Report that specifies on european orders. For Example I have set it up to pull in orders from "Amazon.it". I now wish to include an "AND" or "OR" or "IN" to pull Amazon.de, es and finally fr into the one table. Just wondering which function do I use?

 

[pr2-eugin]

It depends. But the straight forward answer to include various criteria would be OR. How do you obtain the keyword or the search criteria? i.e. European?

 

[KenshiroUK]

It depends. But the straight forward answer to include various criteria would be OR. How do you obtain the keyword or the search criteria? i.e. European?

well we don't I believe orders are split using the it, es, uk, de and fr. That part is fine, I was wondering which I would need to include in my new query to pull those Amazon.IT, FR, DE and ES into same table. So you've said I should use the OR function to pull the specific data from IT, FR, DE and ES into my table?

 

[Brianwarnock]

If you are hard coding in the criteria then why not use Like to pull everything starting with Amazon, else Or or IN will work.

Brian

 

[KenshiroUK]

If you are hard coding in the criteria then why not use Like to pull everything starting with Amazon, else Or or IN will work.

Brian

Theres a .co.uk y'see that we wanna keep separate

 

[jdraw]

Could you please post a jpg of your tables and relationships?
It may just be terminology but " pulls in data from an order report" has me a little confused.

Do you mean OrderTable?
Perhaps you could expand the description of your problem/issue.