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
