Hi Dave,
If I'm following what you're attempting to do, and how your table is set-up,
the following SQL should work:
SELECT searchtext, count(searchtext)
FROM table1
WHERE searchdate > #CreateODBCDateTime(DateAdd("d", -7, Now()))#
AND searchdate <= #today#
Group By searchtext
Order By searchtext
Hope that helps!
David Schwindt
--
David Schwindt
National Archives and Data Management
Office 4N425, Downsview
(416) 739-4448 [EMAIL PROTECTED]
--
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 1:09 PM
To: [EMAIL PROTECTED]
Subject: RE: [CFTALKTor] count multiple occurrences
Guess I wasn't clear, I dont need the total number of records, I need a
breakdown
What I'm storing is search parameters...so if someone searched for "dave"
ten
times during the week then rather than spit out "dave" over ten lines the
ouput would read 10 searches for "dave".
Dave Seddon (p) 997-1803
Internet Software Support Specialist
Workplace Information Directorate, HRDC-DRHC
e-mail: [EMAIL PROTECTED]
Web: http://labour.hrdc-drhc.gc.ca
<SNIP-SNIP>
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Schwindt, David [Ontario]" <[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)
