Hi all,
This may be a very simplistic problem to some of you..but to me (being completely clueless about the program!) i would really appreciate any help you could provide ...

Basically i have three individual tables for Order, Product and Customer...

I need to filter the data from the orders which sutomers place in order to sort out who is entitled to a discount and who is not...therefore I need to input the following queries:

A discount given to customers who have bought in total more than 10 products, or who have the word 'restaurant' in their name.
AND also...
Offer a free trial of a new product, called 'Popsicles' to all customers who have bought 'Honey Loops' or 'Crunchy Corns' but not if they have already bought 'Popsicles'.

Hope someone can tell me how I could input this into the Access using design view! many thanks!