Like this?
select count(searchtext) as daily_total, searchdate, cume(daily_total) as
running_total
from theTable
where searchtext = 'dave'
group by searchdate
The syntax for your database may be different.
************
Hi folks,
In my database I have stored some search parameters named searchtext,
what I want to do is to be able to count how many times that a particular
text (record) has been entered.
So rather than display the searchtext result of "dave" 10 times it would
display once with the count variable of 10.
my current query to get my data is:
SELECT searchtext,searchdate
FROM table1
WHERE searchdate > #CreateODBCDateTime(DateAdd("d", -7, Now()))# AND
searchdate <= #today#
Order By searchtext
Is there an efficient (easy) way to go about this using sql?
I was thinking of maybe using a trigger to check if the text exists and
then
add to a counter but have never used triggers before.
Any thoughts on how this could be handled..
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: [EMAIL PROTECTED]
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
