I have a database with a large amount of records (000's). The records are in the form of. Field 1:Customer Name Field 2:Period Field 3:Product Category Field 4:Sales Value I want to create a query to show me a single sales value for a type of product for a certain period or group of periods. I can do a sum query against Field 4 with a set criteria against Field 3 and this will return a single total for that product type but if i try to include extra criteria, for example only select records where the Period (Field 2) is for example greater than 2 but less than 7 then it returns the results in more than one line. How can I do this so that the result is only displayed as a single total. THanks

Sorted it now, bit of trial and error with Operator commands!