Right Trying to explain this one as best I can. This is a mock up of the situation A query takes all order id's for a product and multiplies by the number ordered and displays sorted by customer e.g. surname product name cost quantity total for order bloggs pen £5 4 £20 bloggs paper £10 8 £80 Smith pencil £1 100 £100 Smith rubber £1 20 £20 On the report duplicate fields are hidden and a total per customer is displayed e.g. Bloggs Total £80 Smith Total £ 120 But now I want to tell the report to only display a particular customer (there is a primary id field) IF their total order is more than £100. As the student will produce a loyalty bonus card scheme for high spending customers So I can advise the easy option to sort by Total on the report and put in an unbound IF to display a GIVE LOYALTY CARD statement, but for the life of me cannot see how to define an IF statement to only display a customer whose total order value is more than 100 based in the custmer ID or is there some SQL or vba I should be using? Any ideas? Does this make sense?