CREATE VIEW vwEntries (Month,entrycount) as select (IMON(EntryDate)),entrycount from .. SELECT Month,sum(entrycount) from …. Group by month
Albert > On Dec 21, 2016, at 11:40 AM, Bruce Chitiea <[email protected]> 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 [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <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 [email protected]. For more options, visit https://groups.google.com/d/optout.
