Dan
There seems to be an iphone app for everything else....
I can (and do) spool and process the file, just wondered it there was a
more "integrated" way of doing it!
Regards
Simon
On 26/09/2010 14:12, Daniel Klein wrote:
There's no iphone app that will do that? ;-)
Seriously, you would spool the report to a file and then post-process
the file.
Dan
On Sun, Sep 26, 2010 at 7:00 AM, Simon Verona <[email protected]
<mailto:[email protected]>> wrote:
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]
<mailto:[email protected]>
To unsubscribe, send email to [email protected]
<mailto:[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
