Simon:
why not add WITH 2 NE "0" to end of your inquiry ? Dave Keep in mind, I've been out of the loop for a while now :)) > Date: Sun, 26 Sep 2010 12:00:15 +0100 > From: [email protected] > To: [email protected] > Subject: Re: jdbc > > Hi all > > This may or may not be a stupid question. > > I have a transaction file, with many thousands of entries in, which > should total zero both on a daily basis (there is a date field in the > file) and overall. > > If I have a problem, then a check is to find which dates do not come > back to zero... > > So, I execute a jQL query like : > > SORT TRANSACTIONS BY DATE BREAK-ON DATE "'VL'" TOTAL 2 (D) > > Which produces a list like : > > 02/07/2010 0.00 > 01/07/2010 0.00 > 30/06/2010 0.00 > 29/06/2010 -585.31 > 28/06/2010 0.00 > 27/06/2010 0.00 > etc etc > > All I want to see though is the dates that don't come to zero.... > > Can this be done using jQL? > > Thanks > Simon > > -- > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > IMPORTANT: Type T24: at the start of the subject line for questions specific > to Globus/T24 > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
