Create temp view MonthBreakout (EntryDate, EntryCount, EntryMonth) + AS SELECT EntryDate, EntryCount, (IMON(EntryDate)) + FROM tablename
SELECT EntryMonth, SUM(EntryCount) from MonthBreakout + WHERE blah blah + GROUP BY EntryMonth On Wed, Dec 21, 2016 at 1:40 PM, Bruce Chitiea <rby...@safesectors.com> wrote: > All: > > RBXE current > > Maybe it's the season. Brain cells flew down to Costa Rica, or something. > > I have a table with two columns of interest: > > entrydate DATE - sequential daily calendar dates for one calendar year > entrycount INTEGER - total number of events for each date > > I need to aggregate the daily entrycount values into monthly entrycount > totals, producing this: > > 1 (Jan total entrycount) > 2 (Feb total entrycount) > . > . > 12 (Dec total entrycount) > > Having failed numerous attempts at GROUP BY with (IMON(entrydate)) > structures .... what? > > Thanks so much, > > Bruce Chitiea > SafeSectors, Inc. > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rbase-l+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
