Hi Don't worry, I've fixed this by making 2 TQuery's, one for Export and one for the rest and putting them in series on the report. Mark Mark Howard wrote: > Hello > I am trying to construct a SQL query (Paradox) in preparation for > printing a Q/Report and need some advice. > > There is a field called Grade which has values of [Export, a > series of individual others]. I want to sort so that I can > report on the totals for [Export] and then the totals for [All > the others together] ie only a two way sort. > > Is this possible, or is there a better way of doing it? > > TIA > > Mark
begin:vcard n:Howard;Mark tel;cell:(021) 477 564 tel;fax:(07) 348 8178 tel;work:(07) 348 8177 x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Forest Production Systems Ltd end:vcard
