Sent via BlackBerry by AT&T -----Original Message----- From: [email protected] Sender: [email protected] Date: Thu, 13 Mar 2014 22:33:37 To: Abridged Recipients<[email protected]> Reply-To: [email protected] Subject: Abridged summary of [email protected] - 6 Messages in 1 Topic
============================================================================= Today's Topic Summary ============================================================================= Group: [email protected] Url: http://groups.google.com/group/jbase/topics - Summing transactions - JBASE 5.1 [6 Updates] http://groups.google.com/group/jbase/t/57a5881e043a228e ============================================================================= Topic: Summing transactions - JBASE 5.1 Url: http://groups.google.com/group/jbase/t/57a5881e043a228e ============================================================================= ---------- 1 of 6 ---------- From: [email protected] Date: Mar 12 05:56PM -0700 Url: http://groups.google.com/group/jbase/msg/9fd43f4131c454a4 On Sunday, March 9, 2014 2:01:46 PM UTC-4, Kevin Powick wrote: > such a summary totals? > -- > Kevin Powick Thank you for your response. We are electronically pushed information on ---------- 2 of 6 ---------- From: "Peter Mowatt" <[email protected]> Date: Mar 12 11:19PM -0400 Url: http://groups.google.com/group/jbase/msg/54c2d15e7d175f3 I get it. I assume that you have no control over the structure of these records. The structure is not built to lend itself to dictionary listing for the discreet output that you want. ---------- 3 of 6 ---------- From: Mark Hogden <[email protected]> Date: Mar 13 06:38AM -0700 Url: http://groups.google.com/group/jbase/msg/f600b63dad5e5ce2 Without seeing the entire dicts for both files, it's hard to say for sure, but on the face of it it sounds like the query should be on the TRANS file with translates back to the ACCOUNT file. ---------- 4 of 6 ---------- From: Kevin Powick <[email protected]> Date: Mar 13 09:05AM -0700 Url: http://groups.google.com/group/jbase/msg/25cd187ce51ad734 > identify the $100 payment using a dictionary item, by taking each account > number and adding the actual payments (marked by a "3" in attribute 9) for > each date together in a sum. ---------- 5 of 6 ---------- From: Chris Mathews <[email protected]> Date: Mar 13 11:38AM -0700 Url: http://groups.google.com/group/jbase/msg/3256e179012db561 Kevin is correct. To give you the right attributes: SORT TRANS WITH 9 EQ "3" BY 1 BY 22.4 BREAK-ON 1 BREAK-ON 22.4 TOTAL SIGNED-TRANS-AMT DET-SUPP. DICT items exist in TRANS already for ---------- 6 of 6 ---------- From: Kevin Powick <[email protected]> Date: Mar 13 02:43PM -0700 Url: http://groups.google.com/group/jbase/msg/daa0a595e58e3473 On Thursday, 13 March 2014 12:05:24 UTC-4, Kevin Powick wrote: > If you just want the totals without the detail, add the clause ID-SUPP to > the end of the above query statement -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. 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 --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. 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 --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
