Hi so I need some help with a query.
I have 2 tables in my database, 1 named Customers, and 2 called Orders.

I have created a Customers Query, and what I want it to have added is a column called "VIP", which either displays "Yes" or "No".
Like this:
\1

Now, I want the VIP status to be calculated.The VIP is stated as "Yes", when the "CustomerID" has appeared in the Orders Table more than 9 times (>9) OR the "CustomerID" has spent over $1200 in the "OrdersTotal" in the Orders Table. Which ever comes first. But if the "CustomerID" does not appear more than 9 times in the Orders Table, or has a sum of OrdersTotal being higher than 1200, I want this VIP value to be "No".

Eg for example the tables:

CUSTOMER
CustomerID
1
2
3
4
5

ORDERS
OrderID--------CustomerID------OrdersTotal
1----------------1-------------------10
2----------------1-------------------10
3----------------1-------------------10
4----------------1-------------------10
5----------------1-------------------10
6----------------1-------------------10
7----------------1-------------------10
8----------------1-------------------10
9----------------1-------------------10
10--------------1-------------------10
11---------------2-------------------2000

So the Customers Query would become:
CUSTOMERS
CustomerID---VIP
1---------------YES
2---------------YES
3---------------NO
4---------------NO
5---------------NO

CustomerID "1" would be "Yes" due to having more than 9 order (>9 orders), while CustomerID "2" would be"Yes" due to having spent more than $1200.


Could anyone help me out here?
I'm using MS Access 2010.
I'd prefer if you could show me the GUI method rather than giving the SQL code. But both is still good.

Thanks.