Dave
Because every individual transaction has a value - it's the break-totals
that are zero...
Simon
On 26/09/2010 12:44, David Grenfell wrote:
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
--
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
