bclark

sorry, the orderItem table contains a summary field to calculate the total order value orderItem(orderItemID, productD, quantity, subtotal -[quantity * product.price] and orderTotal [summary total of subtotal])

Hi folks - thanks for all the help! However, am now trying to return the highest value order each customer has made. I have an order table with orderID, custID, orderTotal (where orderTotal is a summary field) Also other tables with customer data, orderItems data, products etc.... I have managed to produce reports that list each customer and their orders, in descending order of orderTotal using subsummary parts eg the report works well and generates content like..... Customer ID : 213 Customer: Mr Smith Order Date 12/08/13 Order Total £345.66 Order Date 09/10/13 Order Total £79.36 Order Date 01/05/14 Order Total £33.99 Customer ID : 673 Customer: Mrs Jones Order Date 03/07/13 Order Total £49.99 Order Date 11/11/13 Order Total £9.95 etc What I am trying to do is just identify the highest order total for each customer. I thought could use the max summary function, but i cant seem to create a summary field that max's the ordertotal summary field. Ideally, Id like the report to just show.... Customer ID : 213 Customer: Mr Smith Highest Value Order £345.66 Customer ID : 673 Customer: Mrs Jones Highest Value Order £49.99 etc.... I tried to modify the examples above, but to no avail. AGain, any help appeciated! Brian

Thats awesome

... and limit that list to the 10 most expensive products...... Sorry to hear that - I appreciate you tried to help though

Thats really helpful! Thanks very much However, this is my fault, but what I am trying to achieve is a list that contains the most expensive product from each manufacturer eg manufacturer1 most expensive product manufacturer2 most expensive product manufacturer3 most expensive product manufacturer4 most expensive product so only one occurence of the manufacturer name appears in the list..... .... hope that makes some sense! I was trying to use the max function to this. I did find something similar in access here - http://www.databasedev.co.uk/access_max_function.html - and tried to translate into FMP, but to no avail..... Again, really appreciate your help

Hi folks, As a relative newcomer to FMP, I am trying to export some records and am having difficulty..... 2 of the tables in my database are: MANUFACTURER [mName, contact email, contact name] (approx 50 records) PRODUCT [pID, pName, description, price, mName] (approx 300 records) So, a manufacturer makes many products..... I want to export each manufacturers most expensive product, but only the top 10. This is probably quite straight forward, but I just cant quite get my head around it! Any help appreciated. I am using FMP 12 Many thanks Brian