Thanks, Anne. That works a treat.
Cheers, Doug. On Thursday, 23 December 2021 at 06:06:51 UTC-8 Anne Sigman wrote: > Here's an old-school way of doing it. We haven't upgraded yet, but you > might try it. > > TOP > 001 S > 002 0 > 003 \ > 004 > 005 > 006 > 007 > 008 A;"1" > 009 R > 010 0 > > On Wednesday, December 22, 2021 at 2:25:06 PM UTC-5 dfleetham_HMA wrote: > >> Hi All, >> >> We've recently (ish) moved from to 5.8.2 from I have no idea what (4.#?). >> >> In the previous iteration I had a dictionary item that I added to most >> files and it was labelled 'CNT'. It was a fixed value of 1 and looked like: >> >> CNT >> 001 I >> 002 1 >> 003 MR0, >> 004 CNT >> 005 8R >> >> And it was useful for counting records in a report; if I ran a query like: >> >> SORT D:\D_Shared\This Client\ThatCampaign\CUST_GIFT_DATA BY 28 BREAK-ON >> 28 TOTAL 22 TOTAL CNT (ID >> >> I would get something like: >> >> Last Gift. Gift Amt CNT..... >> Year >> >> 2014 $75.00 3 >> 2015 $85.00 4 >> 2016 $95.00 4 >> 2017 $65.00 2 >> 2018 $80.00 3 >> 2019 $90.00 3 >> ======== ======== >> *** $490.00 19 >> >> Having moved to 5.8.2, the CNT dictionary item doesn't seem to work and >> running the same query, I get: >> >> Last Gift. Gift Amt CNT..... >> Year >> >> 2014 $75.00 0 >> 2015 $85.00 0 >> 2016 $95.00 0 >> 2017 $65.00 0 >> 2018 $80.00 0 >> 2019 $90.00 0 >> ======== ======== >> *** $490.00 0 >> >> There's probably a very simple solution; I just haven't found it. Is >> there a better structure for a dictionary item like this? Is there a better >> solution I could be using? >> >> Any help is much appreciated. >> >> Thanks, >> >> Doug. >> > -- -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/ef1594e0-d18a-4bc0-b7bb-1bc87f7761f2n%40googlegroups.com.
