Hi All, Hopefully this is an easy one and I am making a simple error. I am looking at Sales records and pre-selecting the date range. All works fine except I want to calculate a success rate based on a single logical field (scanned). I need to sum the sales value field for both records where this field is value = 1 and also where it is value = 0, then turn these two results into a % success rate to be displayed in a chart. My problem is that I cant see how to get the values SUM (sales value) where scanned = 0 and SUM (salesvalue) where scanned = 1. Any suggestions would be gratefully appreciated. Thanks in advance Mark
Thanks for the help. I think I may have expressed myself badly in the question. i think this solution gives me a total for both possible values of scanned, i need to have two seperate totals for the SUM(salesvalue) so that I can present a % of all salesvalue that are scanned = 1.