Thanks, gentlemen. Much appreciated.
Maybe it's time to shut down for a week.
Wishing you all the best for the season, and an excellent 2017.
Warmest Regards,
Bruce
------ Original Message ------
Sent: 12/21/2016 10:57:25 AM
Subject: Re: [RBASE-L] - Simple SELECT statement: Bad Brains
From: "Albert Berry" <[email protected]>
To: [email protected]
Cc:
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].
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 [email protected].
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
